Re: Case Sensitive problem - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Case Sensitive problem
Date
Msg-id 87fylj2sry.fsf@suzuka.mcnaught.org
Whole thread Raw
In response to Case Sensitive problem  ("Erik Ferencz" <ErikFerencz@seznam.cz>)
List pgsql-general
"Erik Ferencz" <ErikFerencz@seznam.cz> writes:

> Hi,
> I have got problems with case sensitive sort.
> My Postgre DB is Case sensitive but I need case insensitive.
> Could anyone help me,please.
> I don't know where or how to set this option.

It's not an option you can set.  Just do "ORDER BY upper(mycolumn)".

-Doug

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: URGENT!!! SELECT statement please help
Next
From: Chris
Date:
Subject: Re: Case Sensitive problem