trigger wont use internal function?

Поиск
Список
Период
Сортировка
От Robert Treat
Тема trigger wont use internal function?
Дата
Msg-id AMENJOLMNKAEOIGHHILBKELCCBAA.robertt@auctionsolutions.com
обсуждение исходный текст
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Tim Barnard"
Дата:
Сообщение: Re: Language C - Console-based FrontEnd
Следующее
От: "Chad R. Larson"
Дата:
Сообщение: Re: Application Design and PostgreSQL