Re: DO INSTEAD and conditional rules
This is a discussion on Re: DO INSTEAD and conditional rules within the pgsql Hackers forums, part of the PostgreSQL category; --> > > If we did not define > > it that way, I think your example would have to ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-11-2008, 04:36 AM
| ||||
| ||||
 Re: DO INSTEAD and conditional rules > > 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings      |
Linear Mode
