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

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: How to insert into 2 tables from a view?
Дата
Msg-id 1419366138642-5831897.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: How to insert into 2 tables from a view?  (Chris Hoover <revoohc@gmail.com>)
Ответы Re: How to insert into 2 tables from a view?  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-general
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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Hoover
Дата:
Сообщение: Re: How to insert into 2 tables from a view?
Следующее
От: David G Johnston
Дата:
Сообщение: Re: How to insert into 2 tables from a view?