Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread David Fetter
On Wed, Jan 23, 2013 at 02:40:45PM -0500, Bruce Momjian wrote: > On Wed, Jan 23, 2013 at 10:15:27AM -0800, David Fetter wrote: > > On Wed, Jan 23, 2013 at 03:12:37PM -0300, Alvaro Herrera wrote: > > > David Fetter wrote: > > > > On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > > > >

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread Bruce Momjian
On Wed, Jan 23, 2013 at 10:15:27AM -0800, David Fetter wrote: > On Wed, Jan 23, 2013 at 03:12:37PM -0300, Alvaro Herrera wrote: > > David Fetter wrote: > > > On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > > > > Folks, > > > > > > > > Please find attached a patch which implements t

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread David Fetter
On Wed, Jan 23, 2013 at 03:12:37PM -0300, Alvaro Herrera wrote: > David Fetter wrote: > > On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > > > Folks, > > > > > > Please find attached a patch which implements the SQL standard > > > UNNEST() WITH ORDINALITY. > > > > Added to CF4. >

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread Alvaro Herrera
David Fetter wrote: > On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > > Folks, > > > > Please find attached a patch which implements the SQL standard > > UNNEST() WITH ORDINALITY. > > Added to CF4. Surely you meant CF 2013-Next (i.e. first commit of 9.4 cycle). -- Álvaro Herrer

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-22 Thread David Fetter
On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > Folks, > > Please find attached a patch which implements the SQL standard > UNNEST() WITH ORDINALITY. Added to CF4. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype:

[HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-22 Thread David Fetter
Folks, Please find attached a patch which implements the SQL standard UNNEST() WITH ORDINALITY. It doesn't stop there. Any function call in a FROM clause can now take WITH ORDINALITY, which appends a counter (ordinality) column to the columns the function outputs and produce results like this: