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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com

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

2023-07-19 Thread Tom Lane
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 com