Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger for Truncate event - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: Trigger for Truncate event
Date
Msg-id 20090827081731.GL9779@a-kretschmer.de
Whole thread Raw
In response to Re: Trigger for Truncate event  (Jignesh Shah <jignesh.shah1980@gmail.com>)
Responses Re: Trigger for Truncate event  (Jignesh Shah <jignesh.shah1980@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Jignesh Shah
Date:
Subject: Re: Trigger for Truncate event
Next
From: Shane Ambler
Date:
Subject: Re: Install new perl test function in PostgreSQL