Thread: Re: functions that return a dataset or set of rows
"Brian Ward" <brian0@verizon.net> 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
Is it not possible in 7.2? Gaetano Mendola wrote: > "Brian Ward" <brian0@verizon.net> 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 > >
Brian wrote: > Is it not possible in 7.2? > No, not really. > Gaetano Mendola wrote: > > "Brian Ward" <brian0@verizon.net> 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 > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
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 documentation). http://developer.postgresql.org/ -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + Bill Gates made $6.3 Billion selling us MS-DOS?