Re: Full Case INSENSITIVE ... - Mailing list pgsql-admin

From Karel Zak
Subject Re: Full Case INSENSITIVE ...
Date
Msg-id 20010727141744.I23719@ara.zf.jcu.cz
Whole thread Raw
In response to Full Case INSENSITIVE ...  ("Nicola Cisternino" <ncister@tin.it>)
List pgsql-admin
On Fri, Jul 27, 2001 at 01:31:56PM +0200, Nicola Cisternino wrote:
> Hi,
>
> ... We are a Microsoft SQL Server users by many years .... and now we
> would like migrate our applications on PostgreSQL ... .but for us is
> very important the case function in query operations ....
> SQL Server databases can be case-sensitive or case-insensitive depending
> on installation options.
> If a database is case-sensitive, when you search for text data, you can
> use any combination of uppercase and lowercase letters. For example, if
> you are looking for a name such as "Smith," you can use the search
> conditions "=smith" or "=SMITH." ... so as you can search any data with
>  all standard operators ( ">" "<" ... etc...) without lost any record ! ....
>
> It's possible with PostgreSQL ???  ( .... i already know the ILIKE clause .... but it's
> insufficient !! ...)

 What is insufficient? You can use a lot of solutions for case insensitive
oprations, like LIKE/ILIKE, upper(foo)=upper(bar), etc.

 See mailing list arhives, it's already discussed theme.

> It will be a future implementation  ???

 very unsure...

                Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

pgsql-admin by date:

Previous
From: "Nicola Cisternino"
Date:
Subject: Full Case INSENSITIVE ...
Next
From: ecaillava@interlap.com.ar
Date:
Subject: Re: Problem starting postgresql