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