Tom,
> What the RETURNING clause in the rule does is let you define the data
> that should be returned if the rewritten INSERT had a returning clause
> to start with.
Hmmm. Aha, that works:
postgres=# insert into test values ( 'mary' ) returning test1;
test1
-------
mary
So, this should probably be documented to avoid confusion like mine. Will
write something up ...
--
Josh Berkus
PostgreSQL @ Sun
San Francisco