Thread: Re: plpgsql: return multiple result sets or temp table

--- Oksana Yasynska <oksana@athabascau.ca> wrote:
> Jeff,
>
> thank you for the time and suggestion.
> I'm also trying to use SETOF custom_type as a
> solution

I don't believe that works in 7.2.  But if you do make
it work, be sure to tell me how ;-)
That will work with 7.3, but I am assuming that, as
your first message said, you cannot upgrade the
server.
Best of luck.

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

On Wednesday 22 October 2003 01:19 pm, Jeff Eckermann wrote:
> --- Oksana Yasynska <oksana@athabascau.ca> wrote:
> > Jeff,
> >
> > thank you for the time and suggestion.
> > I'm also trying to use SETOF custom_type as a
> > solution
>
> I don't believe that works in 7.2.  But if you do make
> it work, be sure to tell me how ;-)
> That will work with 7.3, but I am assuming that, as
> your first message said, you cannot upgrade the
> server.

Oups... Forgot to mention that we are upgrading to 7.3.. right now:)
That's why custom type seems better solution.

Cheers,
Oksana