Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: remark regarding 4.2.13. Row Constructors
To: pgsql-docs@lists.postgresql.org
From: PG Doc comments form <noreply@postgresql.org>
Cc: jochen.bandhauer@gmx.net
Reply-To: jochen.bandhauer@gmx.net, pgsql-docs@lists.postgresql.org
Date: Mon, 08 Jun 2026 07:42:45 +0000
Message-ID: <178090456543.1285959.7355583344220664853@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/178090456543.1285959.7355583344220664853%40wrigleys.postgresql.org>
Precedence: bulk

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=3D# select (1);
 ?column?
----------
        1
(1 row)

mydb=3D# select (1,2);
  row
-------
 (1,2)
(1 row)

mydb=3D# select ();
ERROR:  syntax error at or near ")"
LINE 1: select ();
                ^
mydb=3D# select row();
 row
-----
 ()
(1 row)

mydb=3D#

Regards
Jochen