Date: Tue, 27 May 2014 22:47:06 -0700 (PDT)
From: creechy <mock@fakebelieve.org>
To: pgsql-sql@postgresql.org
Message-ID: <1401256026003-5805199.post@n5.nabble.com>
In-Reply-To: <20130703190831.GG3592@eldon.alvh.no-ip.org>
References: 
 <CALSLE1PeLH4iqEyT5RH=d4Y3VmrRyxm6rvnV9fNC0++u9h-WWw@mail.gmail.com>
 <1372858894.60580.YahooMailClassic@web161605.mail.bf1.yahoo.com>
 <kr1bl9$96d$1@ger.gmane.org> <20130703152402.GA6492@momjian.us>
 <CALSLE1N-WnxujTjD+ED9u4pjFrUnHbm8zr9+SmMvu5NPAMGw1g@mail.gmail.com>
 <20130703153524.GB6492@momjian.us>
 <CALSLE1Pxn7aL1P4tW5vL6GL7h9V1YrZU2KmFeTaHQ2ok4hb_xg@mail.gmail.com>
 <kr1i4m$s2o$1@ger.gmane.org>
 <CALSLE1Ofnbp=3WqrNQCG8g36w1h5ndwk4o4Vj9ruUHepzsMLHQ@mail.gmail.com>
 <20130703190831.GG3592@eldon.alvh.no-ip.org>
Subject: Re: Unquoted column names fold to lower case
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

Alvaro Herrera-9 wrote
> Dev Kumkar escribi=C3=B3:
>=20
> Aliases are treated just like any other identifier.  The downcasing
> happens in the lexer (src/backend/parser/scan.l), which is totally
> unaware of the context in which this is happening; so there's no way to
> tweak the downcasing behavior for only aliases and not other
> identifiers.

Hi, sorry I know this is an old thread, but I'm running up against the same
issue.

This statement seems to contradict the PostgreSQL documentation regarding
identifiers. From "4.1.1. Identifiers and Key Words" in
http://www.postgresql.org/docs/8.0/static/sql-syntax.html it states

"Quoting an identifier also makes it case-sensitive, whereas unquoted names
are always folded to lower case. For example, the identifiers FOO, foo, and
"foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are
different from these three and each other."

But your statement suggests that even though aliases are treated like any
other identifier, and you can quote an identifier to make it case sensitive,
this is not happening. To me this sounds like a bug.

 Thoughts?


--
View this message in context: http://postgresql.1045698.n5.nabble.com/Unquo=
ted-column-names-fold-to-lower-case-tp5762315p5805199.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql