On Sat, Nov 20, 2010 at 03:48, <caleb.wel...@emc.com> wrote:
> Note the standard also supports unnesting multiple arrays concurrently, the
> rule for handling arrays with different lengths is to use null padding of the
> shorter array.
>
> UNNEST( ARRAY[5,2,3,4],
> ARRAY['hello', 'world'] )
> WITH ORDINALITY AS t(a,b,i);
Hmmm, that means we cannot support multi-array unnest() with our
generic aggregate functions. The function prototype might be like
below, but we don't support such definition.
unnest(anyarray1, anyarray2, ...,
OUT anyelement1, OUT anyelement2, ...)
RETURNS SETOF record
So, we would need a special representation for multi-array unnest().
--
Itagaki Takahiro
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
