Re: [GENERAL] functions for triggers: passing parameters

2001-03-09 Thread Stephan Szabo
On Fri, 9 Mar 2001, Nico wrote: > What is wrong? > > CREATE FUNCTION set_value(text) RETURNS OPAQUE AS ' > DECLARE > val ALIAS FOR $1; > BEGIN > NEW.inf := val; > RETURN NEW; > END; > ' LANGUAGE 'plpgsql'; > > > CREATE TABLE t1 ( > id serial, > inf

Re: [GENERAL] functions for triggers: passing parameters

2001-03-09 Thread Doug McNaught
Nico <[EMAIL PROTECTED]> writes: > What is wrong? [...] > CREATE TRIGGER t1_set_val BEFORE INSERT ON t1 > FOR EACH ROW EXECUTE PROCEDURE set_value('some info'); Trigger functions can't take arguments. -Doug ---(end of broadcast)--- TIP 4: Don