I found something interesting recently: I have a table with a boolean column. When I wrote (low-level) sqlalchemy code, I used constructs like this:
query = query.where(table.c.boolean_column==True) and when executed the query uses '='. In the psql console, however, I had been using 'boolean_column IS true', and my indexes are partial indexes which specify the same (using IS not equals). When I use ==None then I get 'IS NULL'. I'm not sure which is the totally *right* way to do this, but there is a difference. If I wanted to get IS true (or IS false) out of sqlalchemy, how would I do it? -- Jon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en.
