Re: function return value inside a trigger function

On 09/26/12 17:56, joao viegas wrote:
>
> does anybody knows how can I have something like:
> select function_that_returns_int(NEW.field1) into NEW.field2;

I think you want:
select into NEW.field2 function_that_returns_int(NEW.field1);

or even:
NEW.field2 := function_that_returns_int(NEW.field1);

Bosco.