> > So what would you run the SELECT against, another view or table? No, what I meant was: SELECT on main table: fires a rule which updates a view V1 Now, essentially, view V1 has the data I was trying to acquire originally through BEFORE INSERT trigger. When I need the data, I can query view V1. Atri -- Regards, Atri l'apprenant -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general