From: Jordan Reiter <jordan@breezing.com>
To: Ian Barwick <barwick@gmx.net>
To: Chris <csmith@squiz.net>
To: pgsql-sql@postgresql.org
Subject: Re: Case Sensitive "WHERE" Clauses?
Date: Thu, 26 Sep 2002 20:17:35 -0400
Message-ID: <a05100306b9b9537533b5@[63.172.201.5]> (raw)
In-Reply-To: <200209270133.35024.barwick@gmx.net>
References: <a05100312b9b8f9c321b3@[63.172.201.5]>
<5.1.0.14.0.20020927090709.02f125d0@cooee.squiz.net>
<200209270133.35024.barwick@gmx.net>
> > > > Are string comparisons in postgresql case sensitive?
>> >
>> >Yes, unless you specify otherwise.
>> >
>> >Are you sure you are using the right database? I can
>> >reproduce similar results, but only like this:
>>
>> You're using MySQL in these examples .. not Postgres :)
>
>Full points for paying attention ;-)
>
>This, erm, characteristic of the former caused me a lot of grief once...
>
>Anyone know what the ANSI standard is? I don`t recall any other
>database apart from MySQL which default to case-insensitive
>CHAR or VARCHAR columns.
Microsoft Products (SQL Server, Access) are case-insensitive.
I find it hard to understand why it's advantageous that column names are NOT case sensitive, while field content is. You have a *lot* more control over the database columns than you do over the content that goes into the fields. In my opinion, allowing someone to refer to a column as first_name, First_Name, or FIRST_NAME just encourages bad programming.
--
Jordan Reiter mailto:jordan@breezing.com
Breezing.com http://breezing.com
1106 West Main St phone:434.295.2050
Charlottesville, VA 22903 fax:603.843.6931
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-sql@postgresql.org
Cc: jordan@breezing.com, barwick@gmx.net, csmith@squiz.net
Subject: Re: Case Sensitive "WHERE" Clauses?
In-Reply-To: <a05100306b9b9537533b5@[63.172.201.5]>
* 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