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

new and old as parameter in a function

From: "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: new and old as parameter in a function
Date: 2004-05-06 12:24:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

I'm having some trouble, and I would like to receive some input by the
pg community...

I would like to write a failry complex PLPGSQL trigger that calls a
secondary function. The trigger calls the function with the NEW record
that returns a variable of type RECORD whith the NEW variable modified
accordingly to a series of actions.

By Reading the documentation, I understand that I can write a PLPGSQL
function that receives a parameter of type RECORD, and returns a
parameter of type RECORD, and that this function is callable from a


I haven't been able to write what's expressed above...

is there somebody that can provide some help and/or some examples?

thanks in advance,

Riccardo G. Facchini


pgsql-sql by date

Next:From: Tom LaneDate: 2004-05-06 12:51:37
Subject: Re: new and old as parameter in a function
Previous:From: Theodore PetroskyDate: 2004-05-06 11:46:22
Subject: Re: not really SQL but I need info on BLOBs

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