Unix Technical Forum

Re: Case Sensitive problem

This is a discussion on Re: Case Sensitive problem within the Pgsql General forums, part of the PostgreSQL category; --> "Erik Ferencz" <ErikFerencz@seznam.cz> writes: > Hi, > I have got problems with case sensitive sort. > My Postgre DB ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-09-2008, 08:46 AM
Douglas McNaught
 
Posts: n/a
Default Re: Case Sensitive problem

"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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com