From: | "Passynkov, Vadim" <Vadim(dot)Passynkov(at)pathcom(dot)com> |
---|---|
To: | "'Gaetano Mendola'" <mendola(at)bigfoot(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: NEW used in a query that is not in a rule |
Date: | 2004-09-14 20:53:40 |
Message-ID: | C8C8E7457059D5119E4700D0B765DCB8016AA8DE@sinope.inside.pathcom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I am also don't know how use NEW,OLD in plpgsql
but in pltcl possible to use $NEW($my_field), $OLD($my_field)
--
Vadim Passynkov
-----Original Message-----
From: Gaetano Mendola [mailto:mendola(at)bigfoot(dot)com]
Sent: Tuesday, September 14, 2004 2:35 PM
To: pgsql-hackers(at)postgresql(dot)org
Subject: [HACKERS] NEW used in a query that is not in a rule
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,
I'm bouncing on the following problem, I don't know if is a bug or if exist
a different
way to do it.
The following code is not meaningfull but it's an extract of what I'm trying
to do:
CREATE TABLE foo ( field1 INTEGER );
CREATE OR REPLACE FUNCTION trigger_foo()
RETURNS TRIGGER AS'
DECLARE
~ my_field TEXT;
~ my_stat TEXT;
BEGIN
~ my_field = TG_ARGV[0];
~ my_stat = ''SELECT field1 FROM foo where field1 = NEW.'' || my_field;
~ EXECUTE my_stat;
~ RETURN NEW;
END;
' LANGUAGE 'plpgsql';
CREATE TRIGGER check_foo
BEFORE INSERT ON foo
FOR EACH ROW EXECUTE PROCEDURE trigger_foo('field1');
insert into foo values ( 3 );
I got the error in the subject, it's like the EXECUTE open another contest
and
forget that is inside a rule.
Any idea someone ?
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBRzm37UpzwH2SGd4RAnObAKD4G6S6MdvaYsGxjS88sn+u2OJqagCg86ut
tsa/AXBfKtB12sCPBIwJAYc=
=G2DY
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2004-09-14 20:59:17 | Re: NEW used in a query that is not in a rule |
Previous Message | Peter Eisentraut | 2004-09-14 20:49:35 | Re: Is select a transaction starting statement? |