Re: Daily Digest V1 #282

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