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 extensive
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 tempora
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:
>
> t
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
