Re: Rewrite without correlated subqueries

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: Mark Fenbers <Mark(dot)Fenbers(at)noaa(dot)gov>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Rewrite without correlated subqueries
Date: 2009-08-20 21:59:20
Message-ID: dcc563d10908201459l3f0be8c7wfffcb103fd79545b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, Aug 20, 2009 at 3:16 PM, bricklen<bricklen(at)gmail(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message bricklen 2009-08-20 22:03:15 Re: Rewrite without correlated subqueries
Previous Message bricklen 2009-08-20 21:16:04 Re: Rewrite without correlated subqueries