I agree that using searchval.downcase like lower(blah) works fine and I have been doing this since discovering that Postgres searches were case sensitve.
However it is a pain and can still catch you out when you forget and of course it works fine in development. Having a different database in development/test and in production is a recipe for problems however I have not yet bit the bullet and installed postgres locally as it just seems like more complications when I have multiple mysql databases already. I would guess that more people use mysql than anything else. (but I could well be wrong!) Cheers george --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---