From: | Rob Brown-Bayliss <rob(at)ZOOstation(dot)cc> |
---|---|
To: | PGSQL Novice List <pgsql-novice(at)postgresql(dot)org> |
Subject: | Rules Questions |
Date: | 2001-06-11 05:38:08 |
Message-ID: | 992237888.14422.0.camel@ZOOstation.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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======---
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Brown-Bayliss | 2001-06-11 08:09:54 | Multiple Columns Keys - Good or Bad idea? |
Previous Message | Ryan Ho | 2001-06-11 04:18:29 | Re: How do I see all databases and tables?? |