Re: How to insert into 2 tables from a view?

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.