Postgres Pro
Downloads
Home   >   mailing lists

Re: change tuple before insert - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: change tuple before insert
Date
Msg-id 14793.1154523307@sss.pgh.pa.us
Whole thread Raw
In response to change tuple before insert  (<vivek@staff.ownmail.com>)
List pgsql-interfaces
Tree view 
<vivek@staff.ownmail.com> writes:
> How do i change the contents of a tuple for a row level trigger? do i have to return tg_trigtuple or tg_newtuple? The
docis confusing. it says a tg_newtuple can only be used in case of an update>
 

You should not scribble on either of those.  Make a fresh tuple and
return that.
        regards, tom lane

pgsql-interfaces by date:

Previous
From: Andro
Date:
Subject: [libpq] columns binding?
Next
From: Christopher Steffen
Date:
Subject: Re: Help with plpgsql - subst variable value