| 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: | 20040506122433.71668.qmail@web13908.mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-05-06 12:51:37 | Re: new and old as parameter in a function |
| Previous Message | Theodore Petrosky | 2004-05-06 11:46:22 | Re: not really SQL but I need info on BLOBs |