function return value inside a trigger function - Mailing list pgsql-general

From joao viegas
Subject function return value inside a trigger function
Date
Msg-id 1348707360.12684.YahooMailNeo@web171203.mail.ir2.yahoo.com
Whole thread Raw
Responses Re: function return value inside a trigger function
Re: function return value inside a trigger function
List pgsql-general
Hello Good Evening all,

does anybody knows how can I have something like:
select function_that_returns_int(NEW.field1) into NEW.field2;

i.e., getting a function output and assign it to a variable inside the trigger.

in a trigger function?
I'm always getting:
ERROR: SELECT query has no destination for result data

thanks in advance
jtv

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Odd Invalid type name error in postgresql 9.1
Next
From: Bosco Rama
Date:
Subject: Re: function return value inside a trigger function