Tiziano Slack wrote:
> Hello everybody! I'm newbie to plpgsql syntax. Can anyone tell where
> I'm getting wrong?
> INSERT INTO TG_TABLE_NAME SELECT NEW.*;
If you need to build a dynamic query with plpgsql you'll need to
assemble it as a string and use EXECUTE. You can use variables in
comparisons etc. but not as column-names or table-names.
You might want to look at pltcl or plperl etc. if you are going to be
doing a lot of this sort of stuff.
--
Richard Huxton
Archonet Ltd