| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Rewrite without correlated subqueries |
| Date: | 2009-08-20 22:03:15 |
| Message-ID: | 33b743250908201503r10686639s17adc292565c5ee7@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, Aug 20, 2009 at 2:59 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
> 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.
>
Yeah I know, but I was thinking more of replacing this query with vanilla
SQL. Maybe that's just not be feasible.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tripplowe | 2009-08-21 03:17:51 | Rewrite multiple joins... |
| Previous Message | Scott Marlowe | 2009-08-20 21:59:20 | Re: Rewrite without correlated subqueries |