pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: gilberto.castillo@etecsa.cu
To: Maria.L.Wilson-1@nasa.gov
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: constraint triggers
Date: Wed, 28 Sep 2011 09:43:38 -0500
Message-ID: <4E82EC4A020000250004183A@gw.wicourts.gov> (raw)
In-Reply-To: <1317219989.24926.10.camel@gilbertoc.mtcorp.etecsa.cu>
References: <4E83190B.3070604@nasa.gov>
	<1317219989.24926.10.camel@gilbertoc.mtcorp.etecsa.cu>

Gilberto Castillo Martínez<gilberto.castillo@etecsa.cu> wrote:
 
>> CREATE OR REPLACE FUNCTION increment_dataset_granule_count()
 
>>         RETURN NULL;
 
> Replace RETURN NULL for RETURN NEW
 
That won't matter for an AFTER trigger:
 
http://www.postgresql.org/docs/9.0/interactive/trigger-definition.html
 
says:
 
| The return value is ignored for row-level triggers fired after an
| operation, and so they can return NULL.
 
-Kevin



view thread (6+ messages)  latest in thread

Message-ID: <4E82EC4A020000250004183A@gw.wicourts.gov>
Permalink:  ../4E82EC4A020000250004183A@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4E82EC4A020000250004183A@gw.wicourts.gov

 · 

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: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, gilberto.castillo@etecsa.cu, Maria.L.Wilson-1@nasa.gov
  Subject: Re: constraint triggers
  In-Reply-To: <4E82EC4A020000250004183A@gw.wicourts.gov>

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

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