Обсуждение: Trigger return value

Поиск
Список
Период
Сортировка

Trigger return value

От
Brian Slinn
Дата:
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

От
Josh Berkus
Дата:
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