Re: Testing concurrent psql - Mailing list pgsql-hackers

Greg Stark <gsstark@mit.edu> writes:
> "Jim C. Nasby" <decibel@decibel.org> writes:
>> On Wed, May 16, 2007 at 09:43:36AM -0400, Gregory Stark wrote:
>>> I seem to recall there was a way to construct scenarios that returned multiple
>>> result sets via rules but I don't know how to arrange that. Anyone remember?
>> 
>> An ALSO SELECT rule?

> It gives you an error.

Not if you do it correctly.

regression=# create table foo(f1 int);
CREATE TABLE
regression=# create rule r1 as on insert to foo do also 
regression-# ( select 1; select 2; select 3 );
CREATE RULE
regression=# insert into foo values(42);?column? 
----------       3
(1 row)

INSERT 0 1
regression=# 

This shows BTW that PQexec throws away all but the last select-result;
but they are all delivered to the client.
        regards, tom lane