From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Barwick <barwick@gmx.net>
Cc: Chris <csmith@squiz.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Case Sensitive "WHERE" Clauses?
Date: Thu, 26 Sep 2002 23:19:43 -0400
Message-ID: <20455.1033096783@sss.pgh.pa.us> (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>
Ian Barwick <barwick@gmx.net> writes:
> 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.
I believe the spec has a notion of a "collation attribute" attached
to character-type columns. You could define a collation that makes
comparisons case insensitive and then mark selected columns that way.
We don't have anything like that yet, though Tatsuo has been heard
muttering about how to make it happen ...
regards, tom lane
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: tgl@sss.pgh.pa.us, barwick@gmx.net, csmith@squiz.net
Subject: Re: Case Sensitive "WHERE" Clauses?
In-Reply-To: <20455.1033096783@sss.pgh.pa.us>
* 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