trigger wont use internal function?

From: "Robert Treat" <robertt(at)auctionsolutions(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: trigger wont use internal function?
Date: 2001-07-16 16:51:29
Message-ID: AMENJOLMNKAEOIGHHILBKELCCBAA.robertt@auctionsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to use the following trigger:

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

obviously this does exist, since I can do inserts/updates/selects using
lower(). I have also tried creating my own version of a lower function but
it gives me the same message.

Am I missing something? This seems like it should be pretty straightforward.
tia,

robert

Browse pgsql-general by date

  From Date Subject
Next Message stefan 2001-07-16 17:05:34 Getting key value with an insert and using it in another.
Previous Message V Alex Brennen 2001-07-16 16:37:17 Re: html to postgres...