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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Souvik Bhattacherjee <kivuosb(at)gmail(dot)com>
Cc: Michel Pelletier <pelletier(dot)michel(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Method to pass data between queries in a multi-statement transaction
Date: 2019-04-18 16:06:13
Message-ID: CAHOFxGotQ=v4PYz3ThMKc=iqSgTEy_OrzZ1PNNY1OxtW7_H4vQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vikas Sharma 2019-04-18 16:43:41 SQL query
Previous Message Souvik Bhattacherjee 2019-04-18 16:03:22 Re: Method to pass data between queries in a multi-statement transaction