From: Riccardo G. Facchini <abief_ag_-postgresql@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: new and old as parameter in a function
Date: Thu, 6 May 2004 05:24:33 -0700 (PDT)
Message-ID: <20040506122433.71668.qmail@web13908.mail.yahoo.com> (raw)
Hi.
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
Trigger.
But:
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: abief_ag_-postgresql@yahoo.com
Subject: Re: new and old as parameter in a function
In-Reply-To: <20040506122433.71668.qmail@web13908.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox