Re: Case-sensitive

Hi,

On Thursday 25 January 2007 11:52, Alexander B. wrote:
| One developer asked me about case-sensitive, if its possible disable
| Postgres not consider when using comparative functions.
| Eg.:
| select * from people
| where upper(name) like upper('A%');
|
| Is there any parameter that don't take in account case-sensitive, or any
| other way to treat??

name ilike 'a%';
name ~* '^a';

For pattern matching operators you can take a look at
http://www.postgresql.org/docs/8.2/interactive/functions-matching.html

Ciao,
Thomas

--
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----