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
