[sqlalchemy] trouble with postgresql ANY

2013-05-28 Thread Jon Nelson
I'm having difficulty using PostgreSQL's ANY operator (for use with arrays). I've tried several variations of the syntax provided in the documentation, but all I ever get is: AttributeError: 'SQLCompiler' object has no attribute 'visit_any' What am I likely doing wrong? I've tried (using

Re: [sqlalchemy] trouble with postgresql ANY

2013-05-28 Thread Michael Bayer
printing a SQL construct invokes the default dialect which doesn't support Postgresql operators, use compile() for stringification: from sqlalchemy.dialects import postgresql dialect = postgresql.dialect() print stmt.compile(dialect=dialect) On May 28, 2013, at 10:23 AM, Jon Nelson