Guolber <[EMAIL PROTECTED]> writes: > Another way could be: > > names = queryselect(func.upper(users.c.username) == "john".upper()) > > I use this instead of the like/ilike approach since it is more useful > when using indexes (at least that's what i found for postgresql). That > is, of course, if you have an index on UPPER(username).
Due to how some letters have their meanings changed and even their existance change in upper / lower cases, I once read a recommendation that one always use lower instead of upper: it covers more cases and is more effective than upper. -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
