[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Rewrite without correlated subqueries
From:       bricklen <bricklen () gmail ! com>
Date:       2009-08-20 22:03:15
Message-ID: 33b743250908201503r10686639s17adc292565c5ee7 () mail ! gmail ! com
[Download RAW message or body]

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.

[Attachment #3 (text/html)]

<div class="gmail_quote">On Thu, Aug 20, 2009 at 2:59 PM, Scott Marlowe <span \
dir="ltr">&lt;<a href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, \
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div class="im">On Thu, Aug 20, \
2009 at 3:16 PM, bricklen&lt;<a \
href="mailto:bricklen@gmail.com">bricklen@gmail.com</a>&gt; wrote:<br> &gt; \
Interesting idea. Preferably this operation could be done in straight SQL in<br> &gt; \
a single transaction, to fit in with the way our application works, but if<br> &gt; \
that&#39;s not possible I may need to go the temporary table route.<br> <br>
</div>Temp tables can be included in a transaction, and they&#39;re not visible<br>
to other connections.<br>
</blockquote></div><br>Yeah I know, but I was thinking more of replacing this query \
with vanilla SQL. Maybe that&#39;s just not be feasible.<br><br><br>



[prev in list] [next in list] [prev in thread] [next in thread]