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

Re: ODBC driver and refcursors

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Farooq <shorrt_circuit(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC driver and refcursors
Date: 2009-06-02 03:39:49
Message-ID: 4A249F05.9090808@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Farooq wrote:
> Any ideas? Anyone?
> 
> --- On Thu, 5/28/09, Farooq <shorrt_circuit(at)yahoo(dot)com> wrote:
> 
>> From: Farooq <shorrt_circuit(at)yahoo(dot)com>
>> Subject: ODBC driver and refcursors
>> To: pgsql-odbc(at)postgresql(dot)org
>> Date: Thursday, May 28, 2009, 10:25 AM
>> Hi Everyone,
>>
>> I've been using 8.1 server and odbc driver with my
>> application on windows and it has been working fine. I
>> upgraded to 8.3.4 and started seeing issues with some of
>> my
>> queries.
>>
>> Here is the scenario:
>>
>> create table users (userid int, username varchar(10));
>>
>> insert into users values (1,'user1');
>> insert into users values (2,'user2');
>> insert into users values (3,'user3');
>> insert into users values (4,'user4');
>> insert into users values (5,'user5');
>>
>> -- And I have functions similar to this
>>
>> create or replace function test_cursor( refcursor, uid
>> int)
>> returns refcursor as
>> $$
>> BEGIN
>>       open $1 for
>>
>> select userid, username
>> from  users
>> where userid >uid;
>>
>>       return $1;
>> END;
>> $$
>> LANGUAGE 'plpgsql';
>>
>> -- My application sends this query
>>
>> select * from test_cursor('curs',3);
>> fetch all in "curs";

8.2 or later drivers produces 2 result sets for the
query.

>> With 8.1 odbc driver, I get the below rows:
>>
>> userid  |  username
>> --------------------
>> 4    |  user4
>> 5    |  user5
>>
>> And with 8.3 odbc driver, I get
>>
>> test_cursor
>> ---------------
>> curs

Please call SQLMoreResults() or the command which corresponds
to it before calling fetch operation.

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: FarooqDate: 2009-06-02 10:15:06
Subject: Re: ODBC driver and refcursors
Previous:From: Craig RingerDate: 2009-06-01 12:49:08
Subject: Re: ODBC driver and refcursors

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