On Mon, Mar 1, 2010 at 9:10 PM, Ray Madigan <r...@madigans.org> wrote: > > What I want to do is when I do a SELECT on the Catalog and deliver the > result to the user, I want to check to see if the FooKey is in the users > ToDo table and set the value of a column isToDo to true or false depending > on if the FooKey exists in the ToDo table for the user.
you should do this when inserting data (with triggers of course) you can't use rules because a RULE ON SELECT you only can use one SELECT, no INSERT, UPDATE nor DELETE -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL AsesorÃa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql