Re: Case of strings - Mailing list pgsql-general

From cnliou
Subject Re: Case of strings
Date
Msg-id 1077884856.29834.cnliou@so-net.net.tw
Whole thread Raw
In response to Case of strings  ("Simon Windsor" <simon.windsor@cornfield.org.uk>)
List 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:

Previous
From: Sezai YILMAZ
Date:
Subject: PostgreSQL insert speed tests
Next
From: "Bas Scheffers"
Date:
Subject: Re: Help with a query