5 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: SQL for "(col1, col2...
FromSent OnAttachments
Matthew Zwier28 Apr 2008 12:28 
Michael Bayer28 Apr 2008 13:08 
Matthew Zwier28 Apr 2008 13:32 
jason kirtland28 Apr 2008 13:40 
Michael Bayer28 Apr 2008 14:05 
Subject:[sqlalchemy] Re: SQL for "(col1, col2) NOT IN (SELECT ...)"
From:Matthew Zwier (mczw@gmail.com)
Date:04/28/2008 01:32:17 PM
List:com.googlegroups.sqlalchemy

Thanks for the quick reply! I've always been quite impressed with the quality of SA and its support.

I'm a bit swamped at work at the moment but I'll see about putting a 'CREATE TEMPORARY TABLE' patch together.

MZ

On Mon, Apr 28, 2008 at 4:09 PM, Michael Bayer <mike@zzzcomputing.com> wrote:

that's pretty good you came up with that. We haven't placed explicit support for multiple items as the subject of an IN statement. You can do what you have there without _Grouping by saying ClauseList(...).self_group(). I think you're safe with that for now though we should add a "public" function for this purpose at some point.

if its just a matter of saying "CREATE TEMPORARY TABLE" instead of "CREATE TABLE", we can accept a patch for "temporary=True", sure.