On Jan 3, 2013, at 2:40 AM, jo wrote:
Hi all,
I need to use in_(), but in oracle it has a limit of 1000 values,
there's an alternative syntax that can be used successful in oracle and it is:
(field,-1) in ( (123,-1), (333,-1), ... )
I tryed this:
_tuple() is fine,
Thanks Michael :-)
j
Michael Bayer wrote:
On Jan 3, 2013, at 2:40 AM, jo wrote:
Hi all,
I need to use in_(), but in oracle it has a limit of 1000 values,
there's an alternative syntax that can be used successful in oracle and it is:
(field,-1) in ( (123,-1), (333,-1),
Hi all,
I need to use in_(), but in oracle it has a limit of 1000 values,
there's an alternative syntax that can be used successful in oracle and
it is:
(field,-1) in ( (123,-1), (333,-1), ... )
I tryed this:
session.query(Mytable).filter((Mytable.c.id,-1).in_([(123,-1),(333,-1)]) )