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