Re: Trigger function returning null

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Hallgren <thhal(at)mailblocks(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Trigger function returning null
Date: 2004-08-13 16:18:50
Message-ID: 24291.1092413930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Hallgren <thhal(at)mailblocks(dot)com> writes:
> Perhaps you should either change this behavior or make a note it in
> "Writing Trigger Functions in C"?

Okay, I've changed the text thusly:

diff -r1.35 trigger.sgml
434,435c434,437
< A trigger function must return either <symbol>NULL</> or a
< <structname>HeapTuple</> pointer. Be careful to return either
---
> A trigger function must return either a
> <structname>HeapTuple</> pointer or a <symbol>NULL</> pointer
> (<emphasis>not</> a SQL NULL, that is, do not set isNull true).
> Be careful to return either

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-08-13 16:24:28 Re: to_char() and negative intervals
Previous Message Pierre-Frédéric Caillaud 2004-08-13 16:12:34 Reiser4