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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
