Farooq wrote:
>> select * from test_cursor('curs',3);
>> fetch all in "curs";
>>
>> 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
Try dispatching this in two separate calls, instead of a single string
containing two semicolon-separated statements.
I have the vague feeling the ODBC driver may have options that affect
multi-statement queries.
--
Craig Ringer