Re: Changes to functions and triggers

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: Changes to functions and triggers
Дата
Msg-id 394A3EBE.DD424EE8@alumni.caltech.edu
обсуждение исходный текст
Ответ на Changes to functions and triggers  (darcy@druid.net (D'Arcy J.M. Cain))
Ответы Re: Changes to functions and triggers  (darcy@druid.net (D'Arcy J.M. Cain))
Список pgsql-hackers
> This no longer works.  I looked and the docs and it seems that this
> should work instead.
> 
> CREATE FUNCTION make_date(date, int, int, int)
>     RETURNS opaque
>     AS '/usr/pgsql/modules/make_date.so'
>     LANGUAGE 'c';
> CREATE TRIGGER make_edate
>     BEFORE INSERT OR UPDATE ON bgroup
>     FOR EACH ROW
>     EXECUTE PROCEDURE make_date('edate', 'aniv', 'emon', 'eyear');

What if you leave out the quotes on the last line above, so the column
names are actually visible? It looks like the example in the docs might
be a poor choice since the function is intended to manipulate columns,
so the text representation of the column name is being passed in.

Don't know if that is the source of your trouble though...
                 - Thomas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Call for port testing on fmgr changes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Big 7.1 open items