On Tue, Mar 9, 2021, at 10:18, Pavel Stehule wrote:
> What do you mean?
>> More than one unnest() in the same query, e.g. SELECT unnest(..), unnest(..)?
>
> you can do unnest(array1, array2, ...)
Right, I had forgotten about that variant.
But isn't this a bit surprising then:
\df unnest
List of functions
Schema | Name | Result data type |
Argument data types | Type
------------+--------+------------------+----------------------------------------------------------------------------------+------
pg_catalog | unnest | SETOF anyelement | anyarray
| func
pg_catalog | unnest | SETOF record | tsvector tsvector, OUT lexeme text,
OUT positions smallint[], OUT weights text[] | func
(2 rows)
Should there be an entry there showing the VARIADIC anyelement version as well?
I know it's a documented feature, but \df seems out-of-sync with the docs.
/Joel
