Skip site navigation (1) Skip section navigation (2)

Re: BUG #4047: case preserve for columns

From: <Eugen(dot)Konkov(at)aldec(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "John R Pierce" <pierce(at)hogranch(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4047: case preserve for columns
Date: 2008-03-21 16:53:34
Message-ID: 005c01c88b74$1b6aa420$1200a8c0@kharkov.localhost (view raw or flat)
Thread:
Lists: pgsql-bugs
SELECT "Id" AS ID
and this will return 'id' instead of 'ID'

may be is there server configurations variable to be case sensitive?
or return case preserved field names?
or may be I compile manually PostgreSQL to do that?

Because typing SELECT "Id" AS "ID" instead of SELECT ID is boring
else more your variant is less readable

If there no any way to migrate to PostgreSQL without changes application
it seems not good database because of it will too expensive for us to 
migrate to (((


----- Original Message ----- 
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: "John R Pierce" <pierce(at)hogranch(dot)com>; <pgsql-bugs(at)postgresql(dot)org>
Sent: Friday, March 21, 2008 6:43 PM
Subject: Re: [BUGS] BUG #4047: case preserve for columns


> <Eugen(dot)Konkov(at)aldec(dot)com> writes:
>> It is have no any matter to me if it is upshifted or lowershifted on 
>> server
>> sidethe standard does not specify that output of queries MUST be
>> lowershifted/upshifted.
>
> Yes it does.  I quote SQL92 section 5.2 syntax rule 10:
>
>            The <identifier body> of a <regular identifier> is equivalent
>            to an <identifier body> in which every letter that is a lower-
>            case letter is replaced by the equivalent upper-case letter
>            or letters. This treatment includes determination of equiva-
>            lence, representation in the Information and Definition 
> Schemas,
>            representation in the diagnostics area, and similar uses.
>
> In particular "representation in the diagnostics area" would include the
> case of column headings being returned to the client.
>
> If you don't want case folding to happen, you need to use a quoted
> identifier.  In the example you showed,
>
> SELECT "Id" AS ID, ...
>
> it would have been sufficient to leave off the AS clause.
>
> regards, tom lane 


In response to

pgsql-bugs by date

Next:From: IPDate: 2008-03-21 19:00:27
Subject: BUG #4048: Can't install pltcl
Previous:From: Tom LaneDate: 2008-03-21 16:43:29
Subject: Re: BUG #4047: case preserve for columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group