remark regarding 4.2.13. Row Constructors
The Post Office <noreply@postgresql.org>
From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: jochen.bandhauer@gmx.net
Date: 2026-06-08T07:42:45Z
Lists: pgsql-docs
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