| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | ivan <iv(at)psycho(dot)pl>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: arrays |
| Date: | 2003-07-28 02:23:50 |
| Message-ID: | 3F248936.6050502@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Joe Conway may already have written something like this --- look in his
> contrib modules.
>
I did write the function, but it isn't in any of the contrib modules.
Here's a link to the thread:
http://archives.postgresql.org/pgsql-hackers/2002-12/msg00453.php
It was never committed due to dissatisfaction over the fact that table
functions cannot have columns from other FROM clause items as arguments.
Since then Peter pointed out that SQL99 specifically includes this
functionality with the keyword UNNEST, and uses a LATERAL clause to
allow referencing adjacent FROM items. Hopefully I'll find time to
pursue implementing that for 7.5.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Sherry | 2003-07-28 02:34:38 | Re: Error message editing is done (or at least I am) |
| Previous Message | Christopher Kings-Lynne | 2003-07-28 01:52:34 | Re: Error message editing is done (or at least I am) |