| 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
| 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 |