Re: [GENERAL] plpgsql: return multiple result sets or temp table

2003-10-24 Thread Oksana Yasynska
Jeff, thank you for the time and suggestion. I'm also trying to use SETOF custom_type as a solution Oksana ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] plpgsql: return multiple result sets or temp table

2003-10-23 Thread Oksana Yasynska
On Wednesday 22 October 2003 01:19 pm, Jeff Eckermann wrote: > --- Oksana Yasynska <[EMAIL PROTECTED]> 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

Re: [GENERAL] plpgsql: return multiple result sets or temp table

2003-10-22 Thread Jeff Eckermann
--- Oksana Yasynska <[EMAIL PROTECTED]> 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,

Re: [GENERAL] plpgsql: return multiple result sets

2003-10-18 Thread Jeff Eckermann
--- Oksana Yasynska <[EMAIL PROTECTED]> wrote: > Hi all, > > I'm running Postgres 7.2.1 and I need to return > multiple row sets from plpgsql > function. I'm new in plpgsql but according > documentation and everything I > could find in the mailing list I need to switch to > 7.3 to get at least S

[GENERAL] plpgsql: return multiple result sets

2003-10-18 Thread Oksana Yasynska
Hi all, I'm running Postgres 7.2.1 and I need to return multiple row sets from plpgsql function. I'm new in plpgsql but according documentation and everything I could find in the mailing list I need to switch to 7.3 to get at least SETOF rows as a result. I can't really upgrade Postgres now. I