Re: trouble with triggers

Robert Treat writes:

> CREATE TRIGGER formatname BEFORE update OR insert ON mytable FOR EACH row
> EXECUTE PROCEDURE lower(name);
>
> however, it gives me the message:
>
> ERROR: CreateTrigger: function lower() does not exist

No function lower() exists that has an argument signature that makes it
suitable as a trigger function. Read your definition again; it makes no
sense because the result of lower() is not used anywhere.

Check out the programmer's guide about how to make trigger functions.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter