Re: Syntax error in trigger

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 <
akretschmer(at)spamfence(dot)net> wrote:

> Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>