Regarding Mutiple cursor returning in PostGres

From: "Sangaran" <skannan(at)ivesia(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Regarding Mutiple cursor returning in PostGres
Date: 2005-09-11 07:41:44
Message-ID: 002801c5b6a4$43765f10$9a02a8c0@ivesia82
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi All,

Can any help me in writing a stored procedure in which it returns multiple cursors. Is it possible in PostGres ?.

I need the way like this

BEGIN
OPEN CURSOR c1
select * from table1 where column1>expression;
OPEN CURSOR c2
select * from table2 where column2>expression;
RETURN c1,c2;
END

Is this possible?

Pls reply if any solution.

regards,
-sangaran

Browse pgsql-odbc by date

  From Date Subject
Next Message Aaron Frantisak 2005-09-12 22:33:55 Frontend/Backend protocol 3.0 update
Previous Message Craig 2005-09-11 06:14:17 Re: ODBC Driver on Windows 64 bit