The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/18/sql-expressions.html Description:
Hi, in https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS there is: "The key word ROW is optional when there is more than one expression in the list." I think it should be: "The key word ROW is optional when there are more than zero expressions in the list." Test Case: [postgres@lin5 ~]$ psql mydb psql (19beta1) Type "help" for help. mydb=# select (1); ?column? ---------- 1 (1 row) mydb=# select (1,2); row ------- (1,2) (1 row) mydb=# select (); ERROR: syntax error at or near ")" LINE 1: select (); ^ mydb=# select row(); row ----- () (1 row) mydb=# Regards Jochen
