Re: Case Sensitive problem

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: "Erik Ferencz" <ErikFerencz(at)seznam(dot)cz>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case Sensitive problem
Date: 2006-03-15 23:27:13
Message-ID: 87fylj2sry.fsf@suzuka.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Erik Ferencz" <ErikFerencz(at)seznam(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-03-15 23:28:14 Re: Case Sensitive problem
Previous Message Ben 2006-03-15 23:23:14 Re: URGENT!!! SELECT statement please help