pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / 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