public inbox for [email protected]  

help / color / mirror / Atom feed

From: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: remark regarding 4.2.13. Row Constructors
Date: Mon, 08 Jun 2026 07:42:45 +0000
Message-ID: <[email protected]> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: remark regarding 4.2.13. Row Constructors
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox