> > 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.
begin:vcard n:Bateman;Kyle x-mozilla-html:FALSE org:Action Target Inc. adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] title:President x-mozilla-cpt:;0 fn:Kyle Bateman end:vcard
