Hi,
I am looking at the rules section of the postgres doc's and have a few
questions.
IS it possible to have a rule modify a WHERE clause, and what happens if
the rule adds a clause that is in the original clause?
And, assuming that above is possible, cab it be overriden? For example
I would like to have a rule that adds a WHERE clause of status<>'DELETE'
as an example, so that my client app does not need to have this clause
in very select.
But at other times I woulkd like to be able to select all rows where the
statsu is delete.
--
Rob Brown-Bayliss
---======o======---