On Apr 28, 2008, at 3:28 PM, Matthew Zwier wrote:
Hi all,
I'm trying to run a (non-ORM) query of the form:
SELECT job_id, pathname FROM jobfilesTable WHERE (job_id, pathname)
NOT IN (SELECT job_id, pathname FROM tempTable)
After searching the docs and the mailing list, the best I've
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 [EMAIL PROTECTED] wrote:
This could be expanded slightly to include 'prefixes=[]' support ala
select() and insert(). Sqlite could use that for creating full text
tables, e.g. 'CREATE VIRTUAL TABLE foo (...) USING ...'.
I haven't thought about this extensively but I think I'd prefer
prefixes=['TEMPORARY'] to a
On Apr 28, 2008, at 4:41 PM, jason kirtland wrote:
This could be expanded slightly to include 'prefixes=[]' support ala
select() and insert(). Sqlite could use that for creating full text
tables, e.g. 'CREATE VIRTUAL TABLE foo (...) USING ...'.
I haven't thought about this extensively