Re: unnest - Mailing list pgsql-hackers

From Joe Conway
Subject Re: unnest
Date
Msg-id 41AB5B2C.1080204@joeconway.com
Whole thread Raw
In response to Re: unnest  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: unnest  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Bruce Momjian wrote:
> I assume this is not something for our PostgreSQL CVS, even the later
> SRF implementation.

I agree with that assessment, at least in its present state. For example:

regression=# select * from unnest(array[[1,2,3],[4,5,6]]); unnest
--------      1      2      3      4      5      6
(6 rows)

Per SQL99 I think that ought to return something like:

-- output faked
regression=# select * from unnest(array[[1,2,3],[4,5,6]]); unnest
-------- {1,2,3} {4,5,6}
(2 rows)

Problem is that a polymorphic SRF cannot (currently at least) both 
accept and return type anyarray.

Joe



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Stopgap solution for table-size-estimate updatingproblem
Next
From: Tom Lane
Date:
Subject: Re: Stopgap solution for table-size-estimate updatingproblem