Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger return value - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Trigger return value
Date
Msg-id 200310071253.27838.josh@agliodbs.com
Whole thread Raw
In response to Trigger return value  (Brian Slinn <brian@welcomebay.co.uk>)
List pgsql-novice
Tree view 
Brian,

> I have a trigger which sets a field value prior to insert and I want to
> know what that value is. Is it possible to return this value from the
> trigger so that it appears in the resultset of the sql command?

No, sorry.   Triggers do not return anything other than success to the client.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: perlsub
Next
From: Josh Berkus
Date:
Subject: Re: dropping users that start with ';'