[GENERAL] Returning a row from a function with an appended array field

2011-11-09 Thread Wes Cravens
I have an adjacency list kind of table CREATE TABLE thingy ( id int, parent int ); I'd like to be able to write a procedural function that returns a row or rows from this table with an appended field that represents the children. Something like this pseudo code: FOR row IN SELEC

Re: [GENERAL] Returning a row from a function with an appended array field

2011-11-09 Thread Wes Cravens
On 11/9/2011 7:34 PM, David Johnston wrote: > On Nov 9, 2011, at 20:19, Wes Cravens wrote: > >> I have an adjacency list kind of table >> >> CREATE TABLE thingy ( >>id int, >>parent int >> ); >> >> I'd like to be able to write a

Re: [GENERAL] Returning a row from a function with an appended array field

2011-11-10 Thread Wes Cravens
On 11/9/2011 7:19 PM, Wes Cravens wrote: > I have an adjacency list kind of table > > CREATE TABLE thingy ( > id int, > parent int > ); > > I'd like to be able to write a procedural function that returns a row or > rows from this table with an ap

Re: [GENERAL] Returning a row from a function with an appended array field

2011-11-10 Thread Wes Cravens
On 11/10/2011 12:05 PM, David Johnston wrote: > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Wes Cravens > Sent: Thursday, November 10, 2011 11:54 AM > To: pgsql-general@postgresql.org > Sub