pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Doc: improve description of IN and row-constructor comparisons.
Date: Wed, 19 Jul 2023 15:00:58 +0000
Message-ID: <E1qM8fh-000HqT-E5@gemulon.postgresql.org> (raw)

Doc: improve description of IN and row-constructor comparisons.

IN and NOT IN work fine on records and arrays, so just say that
they accept "expressions" not "scalar expressions".  I think that
that phrasing was meant to say that they don't work on set-returning
expressions, but that's not the common meaning of "scalar".

Revise the description of row-constructor comparisons to make it
perhaps a bit less confusing.  (This partially reverts some
dubious wording changes made by commit f56651519.)

Per gripe from Ilya Nenashev.  Back-patch to supported branches.
In HEAD and v16, also drop a NOTE about pre-8.2 behavior, which
is hopefully no longer of interest to anybody.

Discussion: https://postgr.es/m/168968062460.632.14303906825812821399@wrigleys.postgresql.org

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/22d0c30bd9662e48fb0d27253fec6a43c7673f13

Modified Files
--------------
doc/src/sgml/func.sgml | 30 ++++++++++++++----------------
1 file changed, 14 insertions(+), 16 deletions(-)



view thread (7+ messages)

Message-ID: <E1qM8fh-000HqT-E5@gemulon.postgresql.org>
Permalink:  ../E1qM8fh-000HqT-E5@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1qM8fh-000HqT-E5@gemulon.postgresql.org

 · 

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: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Doc: improve description of IN and row-constructor comparisons.
  In-Reply-To: <E1qM8fh-000HqT-E5@gemulon.postgresql.org>

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

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