Re: basic trigger using OLD not working? - Mailing list pgsql-general

On Fri, 2005-02-25 at 17:14 -0700, Rick.Casey@colorado.edu wrote:
> Yes, thank you, I corrected my function from statement level to row level.
> This did get rid of the error message. However, I still get no output from
> an OLD variable that should contain data: see the test variable in the
> simple case below.
> ...
> >     RAISE EXCEPTION ''OLD.famindid = '', test;

as has already been pointed out, you need to put a % marker
in your format string.

  RAISE EXCEPTION ''OLD.famindid = %'', test;


gnari