Re: Changes to functions and triggers - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Changes to functions and triggers
Date
Msg-id 394A3EBE.DD424EE8@alumni.caltech.edu
Whole thread Raw
In response to Changes to functions and triggers  (darcy@druid.net (D'Arcy J.M. Cain))
Responses Re: Changes to functions and triggers  (darcy@druid.net (D'Arcy J.M. Cain))
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Call for port testing on fmgr changes
Next
From: Tom Lane
Date:
Subject: Re: Big 7.1 open items