On Tuesday, 10 December 2013 01:00:51 UTC-5, Michael Bayer wrote:
that’s a little strange but you can get around it using CAST:
match = session.query(MyTable).\
filter(MyTable.myset == cast(z, ARRAY(String))).\
all()
Unfortunately, that doesn't work.
On Tuesday, 10 December 2013 03:29:48 UTC-5, Matthew Pounsett wrote:
On Tuesday, 10 December 2013 01:00:51 UTC-5, Michael Bayer wrote:
that’s a little strange but you can get around it using CAST:
match = session.query(MyTable).\
filter(MyTable.myset == cast(z,
On Dec 10, 2013, at 3:29 AM, Matthew Pounsett matt.pouns...@gmail.com wrote:
On Tuesday, 10 December 2013 01:00:51 UTC-5, Michael Bayer wrote:
that’s a little strange but you can get around it using CAST:
match = session.query(MyTable).\
filter(MyTable.myset == cast(z,
On Tuesday, 10 December 2013 10:00:20 UTC-5, Michael Bayer wrote:
the test case I’m using is below. You might want to make sure you’re on
the latest psycopg2, this is also SQLAlchemy 0.8.4 but the SQL output seems
the same. Overall, if maybe you’re on an older postgresql version, you
I'm trying to work with the postgres ARRAY type and I'm having a hard time
figuring out what I'm doing wrong with filtering queries on the array
column. Here's some sample code, omitting the session setup:
class MyTable(Base):
On Dec 10, 2013, at 12:00 AM, Matthew Pounsett matt.pouns...@gmail.com wrote:
I'm trying to work with the postgres ARRAY type and I'm having a hard time
figuring out what I'm doing wrong with filtering queries on the array column.
Here's some sample code, omitting the session setup: