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,
> info text
> );
> CREATE TRIGGER t1_set_val BEFORE INSERT ON t1
> FOR EACH ROW EXECUTE PROCEDURE set_value('some info');
>
> ============================
> psql 7.1beta5 result:
>
>
> CREATE
> psql:function_for_trigger.sql:15: NOTICE: CREATE TABLE will create implicit
> sequence 't1_id_seq' for SERIAL column 't1.id'
> psql:function_for_trigger.sql:15: NOTICE: CREATE TABLE/UNIQUE will create
> implicit index 't1_id_key' for table 't1'
> CREATE
> psql:function_for_trigger.sql:17: ERROR: CreateTrigger: function set_value()
> does not exist
> test=#
>
> (the language plpgsql is already loaded)
Right, because triggers take arguments differently. Trigger functions
must return opaque and take no arguments. Arguments passed at create
trigger time are passed in via TG_ARGV[] (number in TG_NARGS i believe)
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
