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.