Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group