From: Varun Kacholia <varunk@cse.iitb.ac.in>
To: pgsql-general@postgresql.org
Subject: Case sensitivity
Date: Thu, 20 Jun 2002 19:50:40 +0530
Message-ID: <20020620195306.B25394@voxel.cse.iitb.ac.in> (raw)
Hi,
Well while moving from Mysql to POstgresql this was one more difference
: Case Sensitivity.
The problem is in this query
select * from table where name='Word'
select * from table where name='word'
Mysql treated both as same but postgres does not..i appreciate that
it is good but is there a way that 'Word' can be matched with 'word'?
i mean my queries can specify whether to be case sensitive or not.
is there any such provision in postgres?
or is it always case sensitive?
thanks
--
------
Varun
It is easier to write an incorrect program than understand a correct one
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: varunk@cse.iitb.ac.in
Subject: Re: Case sensitivity
In-Reply-To: <20020620195306.B25394@voxel.cse.iitb.ac.in>
* 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