From: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Nicola Cisternino <ncister(at)tin(dot)it> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Full Case INSENSITIVE ... |
Date: | 2001-07-27 12:17:44 |
Message-ID: | 20010727141744.I23719@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
From | Date | Subject | |
---|---|---|---|
Next Message | ecaillava | 2001-07-27 12:46:02 | Re: Problem starting postgresql |
Previous Message | Nicola Cisternino | 2001-07-27 11:31:56 | Full Case INSENSITIVE ... |