Hello everybody,
I have the table (named for example "mytable") and trigger on insert. The
trigger do the following (in real trigger the logic is more complicated, but
there is no difference for this question):
INSERT INTO another_table VALUES (NEW.*);
RETURN NULL;
And i want to do the following:
INSERT INTO "mytable" VALUES ('blah', 'blah', 'blah') RETURNING *;
But result is empty. I've tried to add rule on insert into "mytable" with
returning clause, but there is the problem with one: returning clause will not
be invoked if insert returns nothing. But i really need return value for the
insert.
Any ideas?
--
Regards,
Vladimir Protasov.
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
