pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedfunctions that return a dataset or set of rows
5+ messages / 5 participants
[nested] [flat]
* functions that return a dataset or set of rows
@ 2002-10-15 01:21 Brian Ward <brian0@verizon.net>
0 siblings, 1 reply; 5+ messages in thread
From: Brian Ward @ 2002-10-15 01:21 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: functions that return a dataset or set of rows
@ 2002-10-17 12:58 Gaetano Mendola <mendola@bigfoot.com>
parent: Brian Ward <brian0@verizon.net>
0 siblings, 1 reply; 5+ messages in thread
From: Gaetano Mendola @ 2002-10-17 12:58 UTC (permalink / raw)
To: pgsql-sql
"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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: functions that return a dataset or set of rows
@ 2002-10-17 21:41 Brian <bill@digitalpitstop.com>
parent: Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 2 replies; 5+ messages in thread
From: Brian @ 2002-10-17 21:41 UTC (permalink / raw)
To: pgsql-sql
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: functions that return a dataset or set of rows
@ 2002-10-18 18:01 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Brian <bill@digitalpitstop.com>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2002-10-18 18:01 UTC (permalink / raw)
To: Brian <bill@digitalpitstop.com>; +Cc: pgsql-sql
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, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: functions that return a dataset or set of rows
@ 2002-10-18 22:29 Roberto Mello <rmello@cc.usu.edu>
parent: Brian <bill@digitalpitstop.com>
1 sibling, 0 replies; 5+ messages in thread
From: Roberto Mello @ 2002-10-18 22:29 UTC (permalink / raw)
To: Brian <bill@digitalpitstop.com>; +Cc: pgsql-sql
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-10-18 22:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-15 01:21 functions that return a dataset or set of rows Brian Ward <brian0@verizon.net>
2002-10-17 12:58 ` Gaetano Mendola <mendola@bigfoot.com>
2002-10-17 21:41 ` Brian <bill@digitalpitstop.com>
2002-10-18 18:01 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-10-18 22:29 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox