Chris Hoover-2 wrote > Sorry, in my haste to get the example out, a couple of typo's where in the > sql. Next time, don't quote the entire original wrong query... Anyway, you probably want to create a trigger on your view and do the inserts inside the trigger function. User created CREATE RULE is not usually the correct answer to a problem. David J. -- View this message in context: http://postgresql.nabble.com/How-to-insert-into-2-tables-from-a-view-tp5831876p5831897.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
