Skip site navigation (1) Skip section navigation (2)

Re: Trigger for Truncate event

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Trigger for Truncate event
Date: 2009-08-27 08:17:32
Message-ID: 20090827081731.GL9779@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
In response to Jignesh Shah :
> Thanks Kretschmer. Could you tell me what "return new" meant for?

A trigger function must return either NULL or a record/row value having
exactly the structure of the table the trigger was fired for. Okay, in
this case, you can also return NULL. NEW means the new record, but you
need it only for row level triggers afaik.


Regards, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

Responses

pgsql-novice by date

Next:From: Shane AmblerDate: 2009-08-27 08:58:27
Subject: Re: Install new perl test function in PostgreSQL
Previous:From: Jignesh ShahDate: 2009-08-27 08:07:07
Subject: Re: Trigger for Truncate event

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group