![]() ![]() (a,b) IN ( (1,2), (3,4) )ĪNSI date literals (*) Specify date or timestamps using ANSI literals, e.g. (Yes) (*) Not possible with constant values for an IN clause e.g. Yes (*) Not supported with the BETWEEN operator ![]() (Yes) (*) Not supported for >, or between operators (Yes) (*) ORDER BY is not allowed in the window definition Window string aggregates (*) Use string aggregation as a window function Yes (*) Full parallel query support since Postgres 11 Parallel queries (*) The ability to distribute a single query over serveral CPUs Yes (*) When Postgres compatibility is enabled (Yes) (*) No WHERE clause is allowed e.g. Temporal queries (*) Temporal queries allow querying the database (or a single table) to return the data as it was in the past GROUPING SETS (*) Create multiple independent groups with a single GROUP BY query No (*) The crosstab function can be used for this. in a common table expression directly.įiltered aggregates (*) Only include rows in an aggregate based on a condition: avg(salary) filter (where dept_id = 1) Yes (*) Can only be used in a FROM, not e.g. Sometimes also called "table value constructor". Row constructor (*) Use of the VALUES row-constructor wherever a table reference can be used. A CTE name can not be re-used in the same transaction Can not be used in views Can not be used with sub-queries Can not be used with INSERT statements. (Yes) (*) All columns are treated as varchar. Yes (*) DISTINCT is not supported inside a window functionĬTE in a sub-query (*) Use a common table expression in a sub-query, not only as a top level query To get a more in-depth comparison about some of the SQL features compared here, please visit Modern SQL Oracle Postgres SQL Server IBM DB2 MySQL MariaDB Firebird H2 HSQLDB SQLite Feature Features for database administration or deployment are also not the focus of this comparison. This comparison focuses on SQL features that can be used in SQL statements or self-contained SQL scripts that don't requireĪdditional software (e.g. ![]() (The tooltips don't work on Internet Explorer 10 or older versions. Items with (*) have a comment (or explanation) that is shown as a tooltip when hovering the mouse over them ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |