Re: Disabling case sensitivity

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: ktt <kestutis98(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Disabling case sensitivity
Date: 2002-07-11 16:22:10
Message-ID: 20020711092047.U63911-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Thu, 11 Jul 2002, ktt wrote:

>
> That's a problem, because I building
> a UNICODE text database and planning case insensitive
> search.

You can do case insensitive searches as long as you're
willing to use something other than var=literal (such
as tolower(var)=lowerliteral or tolower(var)=tolower(literal)
or var ILIKE literal).

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Arguile 2002-07-11 16:33:35 Re: Disabling case sensitivity
Previous Message Stephane Schildknecht 2002-07-11 16:17:55 Forcing Disconnection

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-07-11 16:30:12 brk() function and performance
Previous Message Linn Kubler 2002-07-11 16:09:50 syncronizing databases?