Re: Trigger return value

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Brian Slinn <brian(at)welcomebay(dot)co(dot)uk>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Trigger return value
Date: 2003-10-07 19:53:27
Message-ID: 200310071253.27838.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno LEVEQUE 2003-10-07 20:06:26 Re: dropping users that start with ';'
Previous Message Jeff Eckermann 2003-10-07 19:46:59 Re: perlsub