I don't think it's the DAL, I think it's in the drivers or the db systems. Something like this worked on SQLite but Psycopg2 raises an exception:
list_1 = [2,4.5] list_2 = [] db((db.sometable.id.belongs(list_1) & ~(db.sometable.id.belongs(list_2)).select() On Thursday, May 24, 2012 2:35:44 PM UTC-4, Anthony wrote: > > By the way, I don't recommend this. SQLite and Postgres are not plug >> compatible and you may get surprised. >> > > The DAL should make things consistent. Are you aware of something it does > differently on these two databases? > > Anthony >
