Re: Unquoted column names fold to lower case - Mailing list pgsql-sql

From Dev Kumkar
Subject Re: Unquoted column names fold to lower case
Date
Msg-id CALSLE1P_GVeF12dQJT7LJgdh9cZXYN8p3LN=hPWgWA-NWQXpFQ@mail.gmail.com
Whole thread Raw
In response to Re: Unquoted column names fold to lower case  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Thu, Jul 4, 2013 at 1:17 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Quite aside from implementation difficulty, restricting the change to
just column aliases doesn't make it more palatable.  You'd entirely lose
the argument that the change increases spec compliance, because the spec
is perfectly clear that a column alias is an identifier just like any
other.  And you'd still be paying a large part of the application
breakage costs, because the identifiers coming back in query descriptors
are one of the main ways applications would notice such a change.

True, applications will notice and map only the identifiers coming back in query descriptor and in cases when the application reading these resultsets is case-sensitive for descriptors then breakage cost will be there. Hence was all this discussion to reduce the application breakage cost in particular cases.

Regards...

pgsql-sql by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: Unquoted column names fold to lower case
Next
From: Bruce Momjian
Date:
Subject: Re: Unquoted column names fold to lower case