Thread: Trigger return value

Trigger return value

From

Brian Slinn

Date:

07 October 2003, 18:56:28

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?

Thanks

Brian.

Re: Trigger return value

From

Josh Berkus

Date:

07 October 2003, 19:56:10

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