search

m-novikov / tree-sitter-sql

SQL syntax highlighting for tree-sitter
MIT License
110 stars 32 forks source link

Support composite values #54

Open pplam opened 2 years ago

pplam commented 2 years ago

Supported composite values of the form:

(expression1, expression2, ...)

as an expression, and resolved the syntax conflicts.

The conflict is explained at https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-GROUPING-SETS as following

Note The construct (a, b) is normally recognized in expressions as a row constructor. Within the GROUP BY clause, this does not apply at the top levels of expressions, and (a, b) is parsed as a list of expressions as described above. If for some reason you need a row constructor in a grouping expression, use ROW(a, b).

Ref:
https://www.postgresql.org/docs/9.4/rowtypes.html