Re: Non case sensitive - Mailing list pgsql-novice

From Shoaib Mir
Subject Re: Non case sensitive
Date
Msg-id bf54be870608140604rd69bf9dlff7016d204fe0f9b@mail.gmail.com
Whole thread Raw
In response to Non case sensitive  ("roy simkes" <roysimkes@hotmail.com>)
List pgsql-novice
You can use a contrib module "citext" (http://gborg.postgresql.org/project/citext/projdisplay.php) for that purpose.

Thanks,
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 8/14/06, roy simkes < roysimkes@hotmail.com> wrote:
Is there a way that select's where clause can be used as insensitive to the case? I mean:
"SELECT * FROM table WHERE field LIKE 'f' " will return every row that field begins with a "f" or a "F". Without writing " field LIKE 'f' OR field LIKE 'F' " of course.
 
Thanks


Express yourself instantly with Windows Live Messenger! Windows Live Messenger!




pgsql-novice by date:

Previous
From: "roy simkes"
Date:
Subject: Non case sensitive
Next
From: Sean Davis
Date:
Subject: Re: Non case sensitive