David G Johnston wrote > > 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.
Sorry, just noticed the 9.0 so my suggestion is to upgrade :) I'm not sure how best to do this on 9.0 David J. -- View this message in context: http://postgresql.nabble.com/How-to-insert-into-2-tables-from-a-view-tp5831876p5831898.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
