Tom Lane wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:
A Hibernate developer pointed out the following odd behavior to me in 8.2.1:
create table test ( test1 text );
create table test2 ( test_col text );
create rule test_insert as on insert to test do instead insert into test2
values ( NEW.test1 ) RETURNING test2.test_col;
postgres=# insert into test values ( 'joe' );
INSERT 0 1
... no RETURNING.
It would surely be quite broken for an INSERT that has *not* got a
returning clause to spit data at you, don't you think?
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.
Sorry - haven't got a CSV download here, or I'd check myself. Does this
just allow an INSERT...RETURNING inside the rule, or could it be
something like:
CREATE RULE ... AS ON INSERT ... DO INSTEAD SELECT f(NEW.test1);
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
