Skip to content

Postgres support (queries) #44

@nene

Description

@nene

SELECT syntax

  • WITH clause
    • [NOT] MATERIALIZED
    • ( select | values | insert | update | delete ) in addition to just select
    • SEARCH {BREADTH | DEPTH} FIRST BY column_name [, ...] SET search_seq_col_name
    • CYCLE col [, ...] SET cycle_mark_col [TO cycle_mark_value DEFAULT cycle_mark_default] USING cycle_path_col
  • SELECT clause
    • DISTINCT ON (...)
    • empty select (no columns)
  • INTO clause
    • [TEMPORARY | TEMP | UNLOGGED] [TABLE] tablename
  • FROM clause
    • ONLY tablename
    • tablename *
    • AS alias (col1_alias, col2_alias, ...)
    • TABLESAMPLE sampling_method (...) [ REPEATABLE (seed) ]
    • LATERAL (select)
    • LATERAL table_func(..)
    • LATERAL ROWS FROM(..)
    • table function call
    • func(...) WITH ORDINALITY
    • func(...) AS (column_definition, ...)
    • basic ROWS FROM ( func(), ... )
    • ROWS FROM ( func() AS (column_definition, ... ), ... )
    • ROWS FROM ( ... ) [WITH ORDINALITY]
  • GROUP BY clause
    • ALL | DISTINCT
    • ( )
    • (expr1, expr2, ...)
    • ROLLUP (...)
    • CUBE (...)
    • GROUPING SETS (...)
  • WINDOW clause
  • ORDER BY
    • USING operator
    • NULLS {FIRST | LAST}
  • limiting
    • LIMIT count
    • LIMIT ALL
    • OFFSET start [ ROW | ROWS ]
    • FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }
  • FOR clause
    • FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE }
    • OF table_name [, ...]
    • NOWAIT | SKIP LOCKED
  • TABLE clause
    • TABLE ONLY
    • table_name *
    • preceded by WITH
    • in UNION / INTERSECT / EXCEPT
    • followed by ORDER BY, LIMIT, OFFSET, FETCH
    • followed by FOR
  • VALUES clause
    • separate VALUES statement
    • Followed by ORDER BY, LIMIT, OFFSET, FETCH

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions