Oliver,
Thank you very much for clearing that up for me. Learn something
everyday on the postgres lists...
--sean
Oliver Jowett wrote:
> Sean Shanny wrote:
>
>> Make sure you do not end your SQL with a ; (semi colon) as that will
>> cause the fetching part not to work. Don't know why but it does. :-)
>
>
> Technically, "SELECT foo;" is two statements, "SELECT foo" and "", as
> JDBC doesn't require a statement terminator. The (simple-minded) JDBC
> query parser doesn't do anything special to ignore trailing empty
> statements. And you can't DECLARE a cursor that runs two statements..
> so the driver says "two statements, can't use a cursor!".
>
> -O
>