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

Re: Case of strings

From: "cnliou" <cnliou(at)so-net(dot)net(dot)tw>
To: "" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case of strings
Date: 2004-02-27 12:27:36
Message-ID: 1077884856.29834.cnliou@so-net.net.tw (view raw or flat)
Thread:
Lists: pgsql-general
>Is there anyway I can force the PgSQL to accept case 
equivalence, or must I
>add upper()/lower() to force the case and then make string 
tests?
>
> 
>
>Ie Where upper(A)=upper('String')

I think you already answered your own question as pgsql 
document does in section

"9.4. String Functions and Operators"

Regards,
CN

pgsql-general by date

Next:From: Bas ScheffersDate: 2004-02-27 12:29:18
Subject: Re: Help with a query
Previous:From: Sezai YILMAZDate: 2004-02-27 12:15:10
Subject: PostgreSQL insert speed tests

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