Re: Case Preservation disregarding case sensitivity?

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: beau hargis <beauh(at)bluefrogmobile(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case Preservation disregarding case sensitivity?
Date: 2006-11-14 18:43:58
Message-ID: 200611141843.kAEIhwv04665@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

beau hargis wrote:
> Having installed DB2 Enterprise today and taking it for a spin, it does indeed
> behave in a similar manner. However, after reading through both
> specifications, it seems that DB2 follows more of the spec than PostgreSQL.
> The specifications state that for purpose of comparing identifiers, both
> shall be converted to upper-case. DB2 displays all identifiers in upper-case
> whereas PostgreSQL displays all identifiers in lower-case. This alone would
> be a deviation from the specification.

True. We lowercase because historically we have, and because
all-upper-case is hard to read.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-11-14 21:42:23 Re: [HACKERS] Replication documentation addition
Previous Message Shane Ambler 2006-11-14 17:07:41 Re: Help me pack up postgresDB with my windows application.

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2006-11-14 21:11:30 unexpected EOF within message length word
Previous Message Bricklen Anderson 2006-11-14 18:43:02 Re: hiding column values for specific rows