> >Technically, you can also set up a rule to do things on a select with
> >ALSO. However putting update statements in there would be considered
> >least by me) very bad form.  Note that this is not a trigger because
> >does not operate at the row level [I know you knew that already :-)].
> >
> >
> >
> Unfortunately, you can't.  Select operations only allow a single rule,
> and it must be a DO INSTEAD rule, unless this has changed in 8.0 and I
> missed it in the docs.  However, you can do this in a view by calling
> function either in the row definition or in the where clause.

You're right...forgot about that.  Heh, the do instead rule could be a
set returning function which could (besides returning the set) do almost
anything!  So in theory it makes no difference...diclaimer: never tried
doing this!


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to