> How about using > > dbSession.query(models.User).filter(models.User.contains(name))
That generates a LIKE statement , not an ILIKE. I need to case- insensitive match. as a stopgap, i might be able to chain a lower() in there, but something like this should be support. also i'm not so sure what's going on with the sql this generates for postgres: startswith : - LIKE 'jonathan' || '%' contains - LIKE 'jonathan' || '%%' -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
