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@gmx.net http://funkturm.homeip.net/~peter