Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0B7649FB651 for ; Thu, 25 Jan 2007 08:44:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 53384-06 for ; Thu, 25 Jan 2007 08:44:42 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.238]) by postgresql.org (Postfix) with ESMTP id 54F249FB5DB for ; Thu, 25 Jan 2007 08:44:42 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so404041nzh for ; Thu, 25 Jan 2007 04:44:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=lq3ZxNvHvrp/IQuq2wl+rQqPiEiQak6FyK4zJZyZY6INRjtzjR11tvVSnfdftdXakcvvsRHQZtnTDci4XS+wPbQZeVPJbGMTzdk2HkD9n4xlxE6SjmxOaGnMKuQJ+S4lunyTTur2lWnCIRlKubV2IC6fruffVOmx64dVaswJd1I= Received: by 10.65.193.16 with SMTP id v16mr2843030qbp.1169729077157; Thu, 25 Jan 2007 04:44:37 -0800 (PST) Received: by 10.65.188.5 with HTTP; Thu, 25 Jan 2007 04:44:37 -0800 (PST) Message-ID: Date: Thu, 25 Jan 2007 17:44:37 +0500 From: "Shoaib Mir" To: "Alexander B." Subject: Re: Case-sensitive Cc: "pgsql-admin@postgresql.org" In-Reply-To: <45B88BEC.5050209@yahoo.com.br> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15992_3865008.1169729077025" References: <45B88BEC.5050209@yahoo.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/242 X-Sequence-Number: 24398 ------=_Part_15992_3865008.1169729077025 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline '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. 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=E7=E3o para voc=EA! > Experimente j=E1 e veja as novidades. > http://br.yahoo.com/mailbeta/tudonovo/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > ------=_Part_15992_3865008.1169729077025 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 'citext' module (http://gborg.postgresql.org/project/citext/projdisplay= .php) might help you with this....

-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com<= /a>)

On 1/25/07, Alexander B. <burbello3000@yahoo.com.br > wrote:
Hi,

One developer asked me about case-sensitive, if its possibl= e disable
Postgres not consider when using comparative functions.
Eg.:
sele= ct * from people
where upper(name) like upper('A%');

Is t= here any parameter that don't take in account case-sensitive, or any
other way to treat??

Thanks






_________= ______________________________________________
Yahoo! Mail - Sempre a me= lhor op=E7=E3o para voc=EA!
Experimente j=E1 e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/

-------------------------= --(end of broadcast)---------------------------
TIP 2: Don't 'ki= ll -9' the postmaster

------=_Part_15992_3865008.1169729077025--