From: John Clark Naldoza y Lopez <njclark@ntsp.nec.co.jp>
To: scott.gilbert@netregistry.au.com
Cc: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
Date: Tue, 14 Aug 2001 14:47:03 +0800
Message-ID: <3B78C966.4FC8F6CC@ntsp.nec.co.jp> (raw)
References: <NFBBLLGHLDHKCLMNHNBEIEOCCEAA.scott.gilbert@netregistry.au.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: njclark@ntsp.nec.co.jp, scott.gilbert@netregistry.au.com
Subject: Re: Case sensitivity
In-Reply-To: <3B78C966.4FC8F6CC@ntsp.nec.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox