Re: Rewrite without correlated subqueries

<div class="gmail_quote">On Thu, Aug 20, 2009 at 2:59 PM, Scott Marlowe <span dir="ltr"><<a
href="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>></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,
Aug20, 2009 at 3:16 PM, bricklen<<a href="mailto:bricklen@gmail.com">bricklen@gmail.com</a>> wrote:<br /> >
Interestingidea. Preferably this operation could be done in straight SQL in<br /> > a single transaction, to fit in
withthe way our application works, but if<br /> > that'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'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's
justnot be feasible.<br /><br /><br />