Re: [SQL] functions that return a dataset or set of rows

2002-10-18 Thread Roberto Mello
On Thu, Oct 17, 2002 at 05:41:22PM -0400, Brian wrote: > Is it not possible in 7.2? In 7.2 you can return a cursor, which gets close and lets you basically accomplish the goal. See the PL/pgSQL developer documentation for 7.3 (returning cursors was omitted accidentally (?) in the 7.2 documentati

Re: [SQL] functions that return a dataset or set of rows

2002-10-18 Thread Bruce Momjian
Brian wrote: > Is it not possible in 7.2? > No, not really. > Gaetano Mendola wrote: > > "Brian Ward" <[EMAIL PROTECTED]> wrote in message > > news:aofqbd$10v5$1@;news.hub.org... > > > >>How do I create a function that returns a set of row; > >> > >>I can't seem to find the datatype that the r

[SQL] functions that return a dataset or set of rows

2002-10-18 Thread Brian Ward
How do I create a function that returns a set of row; I can't seem to find the datatype that the return set should be declared as. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister

Re: [SQL] functions that return a dataset or set of rows

2002-10-18 Thread Brian
Is it not possible in 7.2? Gaetano Mendola wrote: "Brian Ward" <[EMAIL PROTECTED]> wrote in message news:aofqbd$10v5$1@;news.hub.org... How do I create a function that returns a set of row; I can't seem to find the datatype that the return set should be declared as. You should wait for Pos

Re: [SQL] functions that return a dataset or set of rows

2002-10-17 Thread Gaetano Mendola
"Brian Ward" <[EMAIL PROTECTED]> wrote in message news:aofqbd$10v5$1@;news.hub.org... > How do I create a function that returns a set of row; > > I can't seem to find the datatype that the return set should be declared as. You should wait for Postgres 7.3 currently in beta. Ciao Gaetano