Re: Multi-Table Insert/Update Strategy - Use Functions/Procedures?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Multi-Table Insert/Update Strategy - Use Functions/Procedures?
Дата
Msg-id CAKFQuwZVBZRX059DPc7WGC03sQeapHOaJ_PGe5z_WdmcRkBSbw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multi-Table Insert/Update Strategy - Use Functions/Procedures?  (Bret Stern <bret_stern@machinemanagement.com>)
Список pgsql-general
Дерево обсуждения
On Wed, Jan 27, 2016 at 1:28 PM, Bret Stern <bret_stern@machinemanagement.com> wrote:
On this track (possibly unrelated)...can a view be used as part of the multi table update
Just curious

​Never done so myself but - I believe so though doing so over a one-to-many relationship can be tricky.

That said probably no trickier than do so via a function.  In both scenarios you need to use arrays to approximate sets of records and then decompose the array to insert the relevant records in the "many" table.

David J.


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

Предыдущее
От: Bret Stern
Дата:
Сообщение: Re: Multi-Table Insert/Update Strategy - Use Functions/Procedures?
Следующее
От: Joshua Berkus
Дата:
Сообщение: Re: Multi-Table Insert/Update Strategy - Use Functions/Procedures?