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
|
Список | 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 по дате отправления: