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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Method to pass data between queries in a multi-statement transaction
Дата
Msg-id CAKFQuwbcu84T9rEfrfWycF0PhScEyQNztbLiWY-N7wgVn6BaNg@mail.gmail.com
обсуждение исходный текст
Ответ на 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  (Souvik Bhattacherjee <kivuosb@gmail.com>)
Список pgsql-general
Дерево обсуждения

On Wed, Apr 17, 2019 at 3:04 PM Souvik Bhattacherjee <kivuosb@gmail.com> wrote:
Hello,

I'm trying to pass some values between queries in a multi-statement transaction. For example, consider the following representative multi-statement transaction:

begin;
select * from table1 t1, table2 t2 where t1.cid = t2.cid;
delete from table1 where cid in (values-to-be-populated-from-the-previous-query);
commit;

There are few if any situations where you need to immediately and completely pass all values from one query to another in the same transaction where the queries cannot just be combined into a single statement.  Your representative example is one that is easily combined into a single statement.

Now, the stuff you are trying seems to indicate you are trying to do something in C, inside the engine itself, with all of this.  If that is the case you may want to be more clear as to what you are attempting to do.  But as far as server SQL goes the only persistence area are tables/relations - including temporary ones.

David J.

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

Предыдущее
От: Souvik Bhattacherjee
Дата:
Сообщение: Method to pass data between queries in a multi-statement transaction
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: is it possible to create partitioned tables using tables fromdifferent schemas