> CREATE OR REPLACE FUNCTION update_name() RETURNS opaque AS ' DECLARE BEGIN
NEW.extra:=NEW.first; RETURN NEW;
END; ' LANGUAGE 'plpgsql';
> CREATE TRIGGER update_name_extra BEFORE INSERT ON name EXECUTE PROCEDURE update_name();
> INSERT INTO name(first,last) VALUES('script','head'); ERROR: record "new" is not assigned yet DETAIL: The tuple structure of a not-yet-assigned record is indeterminate. CONTEXT: PL/pgSQL function "update_name" line 4 at assignment