On Mar 27, 2007, at 10:00 AM, Julien Cigar wrote:
> > Hello, > > I'm using SQLAlchemy 0.3.5, and it seems that the func() output is > broken with some functions. > I use the ANY function of PostgreSQL with something like : > func.any(q.c.habitats)==filter_habitat > > SQLAlchemy translates this in: > WHERE any(habitats) = %(any)s, which is incorrect. > > For example: > > the result should be : > iasdev=> select true as result where 'abc' = ANY(array['abc', 'def']); > result > -------- > t > > where SQLAlchemy generates the query as : > > iasdev=> select true as result where ANY(array['abc', 'def']) = 'abc'; > ERROR: syntax error at or near "ANY" at character 29 > LINE 1: select true as result where ANY(array['abc', 'def']) = > 'abc'... > > Is this a bug ? (or maybe it's possible to keep the order...) ? can i have some complete code examples please ? i dont understand how your snippet would produce a full SELECT statement. the phrase youve shown me translates exactly as specified, assuming "filter_habitat" is ia non ClauseElement:: func.any(q.c.habitats)==filter_habitat should be: any(habitats) = %(any)s --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---