Re: Rewrite without correlated subqueries - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Rewrite without correlated subqueries
Date
Msg-id dcc563d10908201459l3f0be8c7wfffcb103fd79545b@mail.gmail.com
Whole thread Raw
In response to Re: Rewrite without correlated subqueries  (bricklen <bricklen@gmail.com>)
Responses Re: Rewrite without correlated subqueries  (bricklen <bricklen@gmail.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: bricklen
Date:
Subject: Re: Rewrite without correlated subqueries
Next
From: bricklen
Date:
Subject: Re: Rewrite without correlated subqueries