Hi,

Can anyone confirm whether I can do something like the following in a
PL/pgsql trigger ( on table tab_a )

	SELECT INTO tab_b * FROM OLD;

or do I have to do -

	INSERT INTO tab_b SELECT * FROM tab_a WHERE id=OLD.id;

All that I want to do is insert the records from OLD into a 2nd table.

Any advice would be gratefully received.

Bernie Warner
JFDI Technology Ltd.


Mon, 16 Jul 2001 13:07:26 +0100
Bernie Warner <Bernie_W@jfdi-tech.com>
OLD in Triggers