In the spirit of tell us what you're trying to do...
I'd like to mimic a subset of Oracle's Virtual Private Database
functionality (see
http://dba-oracle.com/oracle_news/2004_1_16_vpd_security.htm for an
overview) in Postgres: based on some per-connection setting, I'd like a
query to return a
On Wed, Mar 09, 2005 at 13:52:28 -0500,
Doug Bloebaum [EMAIL PROTECTED] wrote:
It's apparent why: the view determines which table it's going to use at
view creation time, not at query time, so this method is no good.
Is there a right way to accomplish what I'm trying to do?
I think the
Check out CREATE RULE command,
Regards,
Qingqing
Doug Bloebaum [EMAIL PROTECTED] дÈëÓʼþ
news:[EMAIL PROTECTED]
[ Sorry if this appears twice on the list: sent it via a non-subscribed
email the first time around. Of course, while waiting for it to appear I
figured out a workaround; see the