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@spamfence.net> wrote:
Jignesh Shah <
jignesh.shah1980@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
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