[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-18 Thread ragnar
Ah, that explains it. Thanks for the answer --~--~-~--~~~---~--~~ 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

[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-17 Thread ragnar
func.lower() was indeed very nice. Thank you for the reply. I seem to have missed the sqlalchemy.func package entirely before and it seems to be rather sparingly documented and it isn't listed in package contents when I do help(sqlalchemy). Is there anywhere where I can read more about the

[sqlalchemy] Re: SQLAlchemy, SQLite: ordering case insensitive

2006-12-17 Thread Michael Bayer
func is just a catchall, whatever attribute you call off of it gets sent to __getattr__ and becomes a function call. its designed to allow any random database-specific call or custom stored procedure. however, it does have some extra tricks going on, in that it will de-parenthesize certain ANSI