Re: Trigger on a column

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Trigger on a column
Дата
Msg-id 43E72C8E.7020607@archonet.com
обсуждение исходный текст
Ответ на Re: Trigger on a column  (Josep Sanmartí <josep.sanmarti@openwired.net>)
Список pgsql-sql
Josep Sanmartí wrote:
> Hi,
>
> readding around I just found this:
> The CREATE TRIGGER statement in PostgreSQL implements a subset of the
> SQL99 standard. (There are no provisions for triggers in SQL92.) The
> following functionality IS MISSING:
> * SQL99 allows triggers to fire on updates to specific columns (e.g.,
> AFTER UPDATE OF col1, col2).
> * .....
>
> Does anybody know if that's true on version postgresql (PostgreSQL)
> 8.1.2? Because I don't actually know from what version that sentence is.

Yes it is true for the current version.

Up-to-date documentation always ships with a release and is also
available on the website.

--   Richard Huxton  Archonet Ltd



В списке pgsql-sql по дате отправления:

Предыдущее
От: Josep Sanmartí
Дата:
Сообщение: Re: Trigger on a column
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Function Dependency