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: (view raw, whole thread or download thread mbox)
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

In response to


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-2017 The PostgreSQL Global Development Group