5. Vector and Ingres : SQL Elements
 
Share this page                  
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.