Hi, Seems that you need to call a function, here are the docs describing how to do this:
http://www.sqlalchemy.org/docs/05/sqlexpression.html#sql_everythingelse_functions Regards, Alex On Oct 2, 3:49 pm, "Ye Xu" <[EMAIL PROTECTED]> wrote: > Hello Everyone, > > database table testArray > > Column | Type > -------------------------- > id | integer > -------------------------- > values | integer[] > -------------------------- > > example data > -------------------------- > id | 1 > -------------------------- > values | {10} > -------------------------- > -------------------------- > id | 2 > -------------------------- > values | {20} > -------------------------- > > if I want to select that 10 in array values, I have to use the following sql > command. > > select * from testArray where 10 = any (values); > > or > > select * from testArray where values[1] = 10; > > my question is : > > how can i convert the above sql commands to sqlalchemy sql expression? > > thx! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---