In this section: |
The following SELECT syntax is supported in Hyperstage.
For more information, see the PostgreSQL 9.2 Documentation.
SELECT [ALL|DISTINCT|DISTINCTROW] SELECT_expr, … [FROM table_references[WHERE where_condition] [GROUP BY {col_name|expr|position}] [HAVING where_condition] [ORDER BY {col_name|expr|position} [ASC|DESC ], …] [LIMIT {[offset,] row_count|row_count OFFSET offset} ] [INTO OUTFILE 'file_name' export_options- AS alias_name- ORDER BY NULL]
For more information, see the PostgreSQL 9.2 Documentation.
Hyperstage supports the following JOIN syntax for the table_references part of SELECT statements (as described in SELECT Syntax).
table_references: table_reference [, table_references] table_reference: table_factor | join_table table_factor: tbl_name [[AS] alias] join_table: table_reference [INNER|CROSS] JOIN table_factor [join_condition] | table_reference STRAIGHT_JOIN table_factor | table_reference STRAIGHT_JOIN table_factor ON condition | table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_condition join_condition: ON conditional_expr | USING (column_list)
For more information, see the PostgreSQL 9.2 Documentation.
SELECT …. UNION [ALL|DISTINCT] SELECT … [UNION [ALL|DISTINCT] SELECT … ]
For more information, see the PostgreSQL 9.2 Documentation.
SELECT * FROM t1 WHERE column1 = (SELECT max(column1) FROM t2);
The following functions are also supported:
WebFOCUS |