Re: upper() vs. lower() - Mailing list pgsql-general

From David Wall
Subject Re: upper() vs. lower()
Date
Msg-id 002b01c0a5c8$765b21a0$5a2b7ad8@expertrade.com
Whole thread Raw
In response to upper() vs. lower()  (Soma Interesting <dfunct@telus.net>)
List pgsql-general
I know that if you move towards unicode, you'll probably do better by going
to lowercase since I understand that there are more lowercase letters than
uppercase (for some odd reason!).  I think it's related to the fact that
some languages have multiple lowercase letters that will map to a single
uppercase letter, so there's great "distinct-ness" with lowercase.

David

> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?
>
> Will initcap() capitalize each word in a column, or just the first word?



pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat
Next
From: Tom Lane
Date:
Subject: Re: function overloading / ambigous functions