remark regarding 4.2.13. Row Constructors

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: jochen(dot)bandhauer(at)gmx(dot)net
Subject: remark regarding 4.2.13. Row Constructors
Date: 2026-06-08 07:42:45
Message-ID: 178090456543.1285959.7355583344220664853@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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(at)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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Daniel Gustafsson 2026-06-09 08:06:20 Re: remark regarding 4.2.13. Row Constructors
Previous Message Ning Sun 2026-06-07 07:40:37 Re: [PATCH] Correct the version sent in protocol negotiation