Re: Method to pass data between queries in a multi-statement transaction

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Method to pass data between queries in a multi-statement transaction
Дата
Msg-id CAHOFxGotQ=v4PYz3ThMKc=iqSgTEy_OrzZ1PNNY1OxtW7_H4vQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Method to pass data between queries in a multi-statement transaction  (Souvik Bhattacherjee <kivuosb@gmail.com>)
Ответы Re: Method to pass data between queries in a multi-statement transaction  (Michel Pelletier <pelletier.michel@gmail.com>)
Список pgsql-general
Thus, what I'm looking for here is way to store the information and then pass that information to the next query efficiently.
For example, is it possible to define a struct of my choice, private to the current transaction, that would store the data and then pass it around to the next query in the transaction without having to materialize that struct (or deal with concurrency issues as in the hash table approach mentioned earlier) .

Perhaps I am missing something obvious, but why not use a temp table? 

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

Предыдущее
От: Souvik Bhattacherjee
Дата:
Сообщение: Re: Method to pass data between queries in a multi-statement transaction
Следующее
От: Vikas Sharma
Дата:
Сообщение: SQL query