Thanks Anreas but I think that's not a issue. The issue is something to do with "$1". I don't know how to get rid of it.
techdb=# INSERT INTO log_table(id) SELECT 5 EXCEPT SELECT id FROM log_table WHERE id = 5; INSERT 0 1 techdb=# select * from log_table; id | txid | txtime ----+--------+---------------------------- 5 | 196552 | 2010-04-22 09:30:10.509326 (1 row) techdb=# Could anyone please help me out here. Thanks, Jignesh On Wed, Apr 21, 2010 at 9:04 PM, Andreas Kretschmer < akretsch...@spamfence.net> wrote: > Jignesh Shah <jignesh.shah1...@gmail.com> wrote: > > > Hi All, > > > > I have written below trigger and applied on the table but it is giving > syntax > > error when it gets invoked. Could you please help me what is wrong? I > have > > given complete details here: > > > > my trigger function: > > > > CREATE OR REPLACE FUNCTION techdb_logtable_trigger() > > RETURNS trigger AS > > $BODY$ > > my $id = $_TD->{new}{'id'}; > > my $query = " > > INSERT INTO log_table(id) > > SELECT $1 > > EXCEPT SELECT id --> throwing error for here: syntax error at or > near > > Select from which table? I think, there is the table-name missing, > right? > > > Andreas > -- > Really, I'm not out to destroy Microsoft. That will just be a completely > unintentional side effect. (Linus Torvalds) > "If I was god, I would recompile penguin with --enable-fly." (unknown) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >