Received: from actarg.com (host25.actarg.com [209.180.91.25] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1SNYXx33668 for ; Wed, 28 Feb 2001 18:34:33 -0500 (EST) (envelope-from kyle@actarg.com) Received: from chi.actarg.com (IDENT:root@chi.actarg.com [192.168.2.16]) by actarg.com (8.9.3/8.9.3) with ESMTP id QAA09600; Wed, 28 Feb 2001 16:34:30 -0700 Received: from actarg.com (IDENT:kyle@localhost [127.0.0.1]) by chi.actarg.com (8.9.3/8.9.3) with ESMTP id QAA13768; Wed, 28 Feb 2001 16:34:40 -0700 Message-ID: <3A9D8B10.8E1DDA92@actarg.com> Date: Wed, 28 Feb 2001 16:34:40 -0700 From: Kyle Organization: Action Target Inc. X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 To: gry@ll.mit.edu CC: pgsql-sql@postgresql.org Subject: Re: Daily Digest V1 #282 References: <200102282320.f1SNKUx32030@mail.postgresql.org> Content-Type: multipart/mixed; boundary="------------9157C0558FADBC3C3D14AC71" X-Archive-Number: 200102/432 X-Sequence-Number: 1637 This is a multi-part message in MIME format. --------------9157C0558FADBC3C3D14AC71 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > > create trigger run_changed_tr after update on runs for each row > execute procedure run_changed(); > > BUT, when I update the table, I get: > ERROR: parser: parse error at or near "$1" > > It looks like the *name* (or it's alias here: $1.run_name), not the *value* of the variable nm, > is passwd to the notify command. Since notify only takes a name, not a string, > I don't see how to proceed. > > Is there some way in plsql to construct a string and have it executed in sql? > > disappointed in plsql, > George > I don't know much about notify, but I know you can build arbitrary SQL strings in PL/TCL. Have you tried that? I use a combination of plpgsql and pltcl in my implementation because each one has it strengths/weaknesses. --------------9157C0558FADBC3C3D14AC71 Content-Type: text/x-vcard; charset=us-ascii; name="kyle.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Kyle Content-Disposition: attachment; filename="kyle.vcf" begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:kyle@actarg.com title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard --------------9157C0558FADBC3C3D14AC71--