From: bricklen <bricklen@gmail.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Rewrite without correlated subqueries
Date: Thu, 20 Aug 2009 15:03:15 -0700
Message-ID: <33b743250908201503r10686639s17adc292565c5ee7@mail.gmail.com> (raw)
In-Reply-To: <dcc563d10908201459l3f0be8c7wfffcb103fd79545b@mail.gmail.com>
References: <33b743250908201332k5e7b0e3fga71a1ec6b44f302a@mail.gmail.com>
<4A8DB4D7.6030102@noaa.gov>
<33b743250908201416h3ec8b61cp4976ab540c4e7cee@mail.gmail.com>
<dcc563d10908201459l3f0be8c7wfffcb103fd79545b@mail.gmail.com>
On Thu, Aug 20, 2009 at 2:59 PM, Scott Marlowe <scott.marlowe@gmail.com>wrote:
> On Thu, Aug 20, 2009 at 3:16 PM, bricklen<bricklen@gmail.com> wrote:
> > Interesting idea. Preferably this operation could be done in straight SQL
> in
> > a single transaction, to fit in with the way our application works, but
> if
> > that's not possible I may need to go the temporary table route.
>
> Temp tables can be included in a transaction, and they're not visible
> to other connections.
>
Yeah I know, but I was thinking more of replacing this query with vanilla
SQL. Maybe that's just not be feasible.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bricklen@gmail.com, scott.marlowe@gmail.com
Subject: Re: Rewrite without correlated subqueries
In-Reply-To: <33b743250908201503r10686639s17adc292565c5ee7@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox