From: Stephan Szabo [mailto:sszabo(at)megazone(dot)bigpanda(dot)com]
Sent: Tuesday, October 31, 2006 10:23 AM
To: Chuck McDevitt
Cc: Tom Lane; beau hargis; pgsql-sql(at)postgresql(dot)org;
Subject: Re: [HACKERS] [SQL] Case Preservation disregarding case
On Tue, 31 Oct 2006, Chuck McDevitt wrote:
> We treated quoted identifiers as case-specific, as the spec requires.
> In the catalog, we stored TWO columns... The column name with case
> converted as appropriate (as PostgreSQL already does), used for
> up the attribute,
> And a second column, which was the column name with the case exactly
> entered by the user.
Wouldn't using that second column's value tend to often violate 5.2SR10
(at least that's the reference item in SQL92)? AFAICT, that rule
says that the regular identifier is equivalent to the case-folded one
purposes of information and definition schema and similar purposes which
seems like it would be intended to include things like column labeling
output. There's a little bit of flexibility there on both similar
and equivalence, though.
Equivalent, yes. But I can interpret that clause it mean I can show
either the case folded or non-case-folded value in the information
schema, as they are equivalent.
Anyway, we have many things that are "enhancements" beyond the spec, and
this could also be considered an enhancement.
In response to
pgsql-hackers by date
|Next:||From: Darcy Buskermolen||Date: 2006-10-31 18:49:37|
|Subject: Re: [HACKERS] Index greater than 8k|
|Previous:||From: David Fetter||Date: 2006-10-31 18:31:40|
|Subject: Re: work on extending PostgreSQL to data integration systems|
pgsql-sql by date
|Next:||From: A. Kretschmer||Date: 2006-10-31 18:48:43|
|Subject: Re: Table Relationships|
|Previous:||From: Stephan Szabo||Date: 2006-10-31 18:22:40|
|Subject: Re: [HACKERS] Case Preservation disregarding case|