Re: DO INSTEAD and conditional rules

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: DO INSTEAD and conditional rules
Дата
Msg-id E1539E0ED7043848906A8FF995BDA5790C514D@m0143.s-mxs.net
обсуждение исходный текст
Ответ на DO INSTEAD and conditional rules  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
> > If we did not define
> > it that way, I think your example would have to error out --- how
> > would you choose which INSTEAD rule wins?
>
> The documentation says that they evaluate in alphabetical order by
> name. So I would expect that the first one to have its WHERE statement
> evaluate to true would short-circuit the execution of the remaining
> rules.

Why not simply write non overlapping WHERE statements ?
Imho not doing them all would be very counter intuitive.

Andreas


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [pgsql-advocacy] Increased company involvement
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [pgsql-advocacy] Increased company involvement