Thread:
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.
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
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