Hello George,
Once, Thursday, March 01, 2001, 12:30:07 AM, you wrote:
GY> [postgres 7.0.2, x86 linux]
GY> I am trying to use a trigger to perform an sql 'notify' command.
GY> I do something like:
GY> CREATE FUNCTION run_changed() RETURNS opaque AS '
GY>declare
GY> nm text;
GY>beg
[postgres 7.0.2, x86 linux]
I am trying to use a trigger to perform an sql 'notify' command.
I do something like:
CREATE FUNCTION run_changed() RETURNS opaque AS '
declare
nm text;
begin
nm := NEW.run_name;
notify nm
return null;
end;
' LANGUAGE 'plpgs
