pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql: Doc: improve description of IN and row-constructor comparisons.
7+ messages / 1 participants
[nested] [flat]

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/bc9993a5497748ca333beac34a8446114bfacce7

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/8286b432c32dbec8b3109c5b09a902adb2385c52

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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

Details
-------
https://git.postgresql.org/pg/commitdiff/15c68cd84a2c80eed9b67ed6746ed5b91baea587

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/27e945944bdb55de0e5362a2a89848fec5cfb45f

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/245d0e6d0d1cc563c986fa34736b111bdf260af0

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fd7c944690b24d3e5bc728c7fb844dec5f7ca92d

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* pgsql: Doc: improve description of IN and row-constructor comparisons.
@ 2023-07-19 15:00  Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Tom Lane @ 2023-07-19 15:00 UTC (permalink / raw)
  To: pgsql-committers@lists.postgresql.org

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



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2023-07-19 15:00 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>
2023-07-19 15:00 pgsql: Doc: improve description of IN and row-constructor comparisons. Tom Lane <tgl@sss.pgh.pa.us>

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