Re: How to manipulate field in New record - Mailing list pgsql-general

From Adrian Klaver
Subject Re: How to manipulate field in New record
Date
Msg-id bc247a58-0530-0cf6-e91c-e829f1db9001@aklaver.com
Whole thread Raw
In response to How to manipulate field in New record  (Lorusso Domenico <domenico.l76@gmail.com>)
Responses Re: How to manipulate field in New record  (Lorusso Domenico <domenico.l76@gmail.com>)
List pgsql-general
On 6/7/23 05:12, Lorusso Domenico wrote:
> Hello,
> Looking for a global solution I've write e trigger function that as 
> optional parameter (argv[0]) receive the name of a specific parameter.
> 
> My need is to get the filed from NEW and OLD record manipulate and set 
> back the field with new value.

A new row won't have the OLD RECORD.

Read:

https://www.postgresql.org/docs/current/plpgsql-trigger.html

and look at the examples.

> 
> Problem 1: how to get and set this field
> Problem 2: the field has Composit type

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: How to manipulate field in New record
Next
From: Lorusso Domenico
Date:
Subject: Re: How to manipulate field in New record