pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
3+ messages / 3 participants
[nested] [flat]
* (no subject)
@ 2003-02-02 21:47 mail.luckydigital.com <jim@luckydigital.com>
0 siblings, 2 replies; 3+ messages in thread
From: mail.luckydigital.com @ 2003-02-02 21:47 UTC (permalink / raw)
To: pgsql-sql
Can some one please confirm( with a plpgsql function example please ) a postgres "7.2" function that can return multiple rows to the client.
I've gone through the docs and can't find anything to support this -it seems you can only have one return value or null.
Yes i'm aware this it is possible in 7.3 - can someone please confirm its not possible in 7.2 or provide me with an example of how to go about it.
Thank you.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PL/pgSQL question
@ 2003-02-02 21:59 Josh Berkus <josh@agliodbs.com>
parent: mail.luckydigital.com <jim@luckydigital.com>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2003-02-02 21:59 UTC (permalink / raw)
To: mail.luckydigital.com <jim@luckydigital.com>; +Cc: pgsql-sql
Jim,
> Yes i'm aware this it is possible in 7.3 - can someone please confirm its
> not possible in 7.2 or provide me with an example of how to go about it.
It is sort of possible in 7.2, as a function can return a cursor to an
interface language capable of handling cursors. However, implementation is
quite cumbersome, and I won't try to detail it here, particularly since that
language and method have been obsolesced and would force you to re-write your
code when you do upgrade.
If this feature is important to you, I strongly recommend that you upgrade to
7.3.1 now.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re:
@ 2003-02-02 22:12 Oliver Elphick <olly@lfix.co.uk>
parent: mail.luckydigital.com <jim@luckydigital.com>
1 sibling, 0 replies; 3+ messages in thread
From: Oliver Elphick @ 2003-02-02 22:12 UTC (permalink / raw)
To: mail.luckydigital.com <jim@luckydigital.com>; +Cc: pgsql-sql
On Sun, 2003-02-02 at 21:47, mail.luckydigital.com wrote:
> Can some one please confirm( with a plpgsql function example please )
> a postgres "7.2" function that can return multiple rows to the client.
>
> I've gone through the docs and can't find anything to support this -it
> seems you can only have one return value or null.
>
> Yes i'm aware this it is possible in 7.3 - can someone please confirm
> its not possible in 7.2 or provide me with an example of how to go
> about it.
Not possible in 7.2 PL/pgSQL
--
Oliver Elphick <olly@lfix.co.uk>
LFIX Limited
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-02-02 22:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-02 21:47 mail.luckydigital.com <jim@luckydigital.com>
2003-02-02 21:59 ` Re: PL/pgSQL question Josh Berkus <josh@agliodbs.com>
2003-02-02 22:12 ` Re: Oliver Elphick <olly@lfix.co.uk>
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