Re: question about AbstractJdbc2Statement

Oliver Jowett <oliver@opencloud.com> writes:
> Luca Ferrari wrote:
>> Can somebody explain me when multiple
>> resultset can be returned from a query?

> stmt.execute("SELECT * FROM table1; SELECT * FROM table2");

Or stmt.execute("UPDATE foo SET ...") where foo has a couple of
ON UPDATE DO ALSO SELECT ... rules.

            regards, tom lane