Views and Rules??? - Mailing list pgsql-general

From Dev
Subject Views and Rules???
Date
Msg-id 6.0.0.22.2.20031001111625.01bffc80@pop3.umpa-us.com
Whole thread Raw
List pgsql-general
Hello all,

I may be going about this all wrong but...
I have a view that selects data from multiple tables(naturally).
The trick i would like to see happen is to have a rule or something rune on
the select of that view to set a bool field to true (t);

Is this even do able?
I noticed that triggers only work on INSERT,UPDATE,DELETE.
I also noticed the rules will run on SELECT as long as you DO INSTEAD SELECT

Thanks to all for the help!



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is the use of array as PL/PGSQL function arguments ?
Next
From: "Bernardo Robelo"
Date:
Subject: Migrating Access to Postgres