"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
Erik Ferencz wrote:
> 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.
What output do you get and what do you expect to get?
It sounds like a locale issue, I'm not sure if you can change this on
the fly though.
--
Postgresql & php tutorials
http://www.designmagick.com/