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
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
