Aaaah, you'll laugh about this. In my transposition of the problem, I
failed to notice an errant ")". So the version I copied and pasted
into my email worked in the first place, but my actual code... did
something else.
Thank you very much for spelling it out, though. It's proved very much
worth my time to wrap my head around this, since every time I
accomplish something like this (over the previous "slurp and reduce"
approach), I reduce the time of about a dozen more function calls by
x50-100 (and there are several more such queries to go).
Thanks again :)
Jason
On 31 March 2010 17:44, Oleg Broytman <p...@phd.pp.ru> wrote:
> print list(Stock.select(
> AND(Stock.q.dbStockCode.startswith("XXX"),
> NOTIN(Outer(Stock).q.id,
> Select(ContItem.q.dbStock)))))
>
> works for me; the query is
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
