Re: Syntax error in trigger

I got it resolved. I just need to put below statement into single quote
instead of double quote. :)

my $query ='INSERT INTO log_table(id) SELECT $1 EXCEPT SELECT id FROM
log_table WHERE id = $1;';

Thanks,
Jignesh

On Thu, Apr 22, 2010 at 2:02 PM, Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>wrote:

> 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
>>
>
>