Re: Case Preservation disregarding case sensitivity? - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Case Preservation disregarding case sensitivity?
Date
Msg-id 200611141843.kAEIhwv04665@momjian.us
Whole thread Raw
In response to Re: Case Preservation disregarding case sensitivity?  (beau hargis <beauh@bluefrogmobile.com>)
List 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@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-sql by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: hiding column values for specific rows
Next
From: Bryce Nesbitt
Date:
Subject: unexpected EOF within message length word