Skip site navigation (1) Skip section navigation (2)

Re: Case-sensitive

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "Alexander B(dot)" <burbello3000(at)yahoo(dot)com(dot)br>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Case-sensitive
Date: 2007-01-25 12:44:37
Message-ID: bf54be870701250444g33ac1fd6t658a96bb12429ce3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
'citext' module (http://gborg.postgresql.org/project/citext/projdisplay.php)
might help you with this....

-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/25/07, Alexander B. <burbello3000(at)yahoo(dot)com(dot)br> wrote:
>
> Hi,
>
> 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??
>
> Thanks
>
>
>
>
>
>
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Responses

pgsql-admin by date

Next:From: Rigmor UkuheDate: 2007-01-25 13:21:25
Subject: Re: Logging just SQL commands in an SQL script format
Previous:From: Thomas PundtDate: 2007-01-25 12:05:47
Subject: Re: Case-sensitive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group