Re: RULE - special variables?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: RULE - special variables?
Дата
Msg-id 4552F3CD.10403@archonet.com
обсуждение исходный текст
Ответ на RULE - special variables?  (Matthew Peter <survivedsushi@yahoo.com>)
Ответы Re: RULE - special variables?  (Matthew Peter <survivedsushi@yahoo.com>)
Список pgsql-general
Matthew Peter wrote:
> Do rules get special variables like triggers? Can I set variables in them like
> triggers?

You get NEW/OLD but they mean something subtly different. Rules act on a
query-tree so they are more like placeholders.

You can't set variables in triggers. You do so in a function. If your
rule calls a function, that could have variables.

Spend some time playing with rules - make sure you understand the
difference between them and triggers.
--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: planer picks a bad plan (seq-scan instead of index)
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: TRIGGERS - access sql query_string that called it?