| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | John Hansen <john(at)geeknet(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: unnest |
| Date: | 2004-11-29 17:23:56 |
| Message-ID: | 41AB5B2C.1080204@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-29 17:44:42 | Re: Stopgap solution for table-size-estimate updatingproblem |
| Previous Message | Greg Stark | 2004-11-29 17:21:06 | Re: Stopgap solution for table-size-estimate updatingproblem |