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.