From: Scott Gilbert <scott.gilbert@netregistry.au.com>
To: pgsql-general@postgresql.org
Subject: Case sensitivity
Date: Tue, 14 Aug 2001 16:09:47 +1000
Message-ID: <NFBBLLGHLDHKCLMNHNBEIEOCCEAA.scott.gilbert@netregistry.au.com> (raw)
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?
Attachments:
[application/ms-tnef] winmail.dat (1.7K, ../NFBBLLGHLDHKCLMNHNBEIEOCCEAA.scott.gilbert@netregistry.au.com/2-winmail.dat)
download
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: scott.gilbert@netregistry.au.com
Subject: Re: Case sensitivity
In-Reply-To: <NFBBLLGHLDHKCLMNHNBEIEOCCEAA.scott.gilbert@netregistry.au.com>
* 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