SQL Elements
For supported SQL data types, statements, functions, and other elements, see the Vector SQL Language Guide.
On the SELECT statement, the following clauses and features are supported:
• WITH common_table_expression
• FIRST rowcount
• ALL, DISTINCT
• GROUP BY
• HAVING
• UNION
• UNION ALL
• INTERSECT
• EXCEPT
• ORDER BY
• Derived tables in FROM clause
• Subqueries (with limitations)
• Joins between Vector tables
• Joins between Ingres tables
• ANSI joins
Note: The CREATE INDEX statement is supported on Vector tables and can be issued only after the table has been created. One clustered index and multiple secondary indexes can be created.
Some SQL elements have restrictions when used in Vector. For more information, see
Incompatibilities with Ingres Database.