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

From Peter Eisentraut
Subject Re: upper() vs. lower()
Date
Msg-id Pine.LNX.4.30.0103052352150.777-100000@peter.localdomain
Whole thread Raw
In response to upper() vs. lower()  (Soma Interesting <dfunct@telus.net>)
List pgsql-general
Soma Interesting writes:

> Is there any reason why everyone suggests to use upper() to do a case
> insensitive search rather than lower()?

I generally use lower()...  So, no.

> Will initcap() capitalize each word in a column, or just the first word?

Each word of the argument.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Getting lengths of variable fields
Next
From: Michael Fork
Date:
Subject: Re: Re: RPMs for PHP accessing PostgreSQL via ODBC over RedHat