Message-ID: <3B78C966.4FC8F6CC@ntsp.nec.co.jp>
Date: Tue, 14 Aug 2001 14:47:03 +0800
From: John Clark Naldoza y Lopez <njclark@ntsp.nec.co.jp>
Organization: NEC Telecom Software
MIME-Version: 1.0
To: scott.gilbert@netregistry.au.com
CC: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
References: <NFBBLLGHLDHKCLMNHNBEIEOCCEAA.scott.gilbert@netregistry.au.com>
Content-Type: text/plain; charset=iso-2022-jp
Content-Transfer-Encoding: 7bit

Hello Scott,


PostgreSQL also supports regular expressions, _VERY_ useful..;-)

~* regular expression, case-insensitive..;-)

Try to get a copy of Bruce's book

Introduction and Concepts
by Bruce Momjian

A sample from the book:
    SELECT * FROM friend  WHERE firstname ~* '[bc]'

read it online, or just read the docs online...;-)

http://techdocs.postgresql.org

Cheers,


John Clark

p.s. don't change PostgreSQL, change your SQL statements...;-)

Scott Gilbert wrote:
> 
> We intend to move from M$ Access to PostgreSQL, however, much of our legacy
> code operates under the assumption that string or text comparisons are case
> insensitive whereas postgres is case sensitive.  This issue extends to SQL
> Select statements as well as straight comparison (i.e. in addition to the <,
> > and = operators, the WHERE and IN clauses in SQL statements are also
> issues) so we can't simply modify the function attached to the comparison
> operators.  Is there some means of modifying the behaviour of PostgreSQL so
> that it is case insensitive?

-- 
     /) John Clark Naldoza y Lopez                           (\
    / )    Software Design Engineer III                      ( \
  _( (_    _  Web-Application Development                    _) )_
 (((\ \>  /_>    Cable Modem Network Management System <_\  </ /)))
 (\\\\ \_/ /         NEC Telecom Software Phils., Inc.  \ \_/ ////)
  \       /                                              \       /
   \    _/  phone: (+63 32) 233-9142 loc. 3113            \_    /
   /   /  cellphone: (+63 919) 399-4742                     \   \
  /   / email: njclark@ntsp.nec.co.jp                        \   \


"Intelligence is the ability to avoid doing work, yet getting the work
done"
--Linus Torvalds