public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dmitry Igrishin <[email protected]>
To: Marko Tiikkaja <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: 36.3 Writing Tigger Functions in C
Date: Tue, 11 Aug 2015 14:51:28 +0300
Message-ID: <CAAfz9KO5WzJY0PH0CsWCTU9W7J09CB85kQT7sZX8AOr9srxgNA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAAfz9KPBchVLG=MxOcD7wWiRjBQJ2CDckqC3RRYrkehy=9wedw@mail.gmail.com>
	<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

2015-08-11 14:32 GMT+03:00 Marko Tiikkaja <[email protected]>:

> On 8/11/15 12:47 PM, Dmitry Igrishin wrote:
>
>> tg_trigtuple:
>> I'm not sure why "skip the operation" is here:
>> "if you don't want to replace the row with a different one (in the
>> case of INSERT) or skip the operation"
>>
>
> Returning NULL from a row-level BEFORE trigger skips the operation which
> fired the trigger.  So for an INSERT, any triggers which would otherwise
> fire after the current trigger are not fired, and the row is not INSERTed
> into the table.

Yes, but it's absolutely unclear in this place of the documentation.
Thus,
"If this trigger was fired for an INSERT or DELETE then this is what you
should return from the function if you don't want to replace the row with a
different one (in the case of INSERT) or skip the operation."
should be replaced with something like
"If this trigger was fired for an INSERT or DELETE then this is what you
should return from the function if you don't want to replace the row with a
different one (in the case of INSERT). (To skip the operation you should
return NULL.)" ?

-- 
// Dmitry.

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: 36.3 Writing Tigger Functions in C
  In-Reply-To: <CAAfz9KO5WzJY0PH0CsWCTU9W7J09CB85kQT7sZX8AOr9srxgNA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox