agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: creechy <mock@fakebelieve.org>
To: pgsql-sql@postgresql.org
Subject: Re: Unquoted column names fold to lower case
Date: Tue, 27 May 2014 22:47:06 -0700 (PDT)
Message-ID: <1401256026003-5805199.post@n5.nabble.com> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Alvaro Herrera-9 wrote
> Dev Kumkar escribió:
>
> 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/Unquoted-column-names-fold-to-lower-case-tp5762315p5805199.h...
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (23+ messages)
Message-ID: <1401256026003-5805199.post@n5.nabble.com>
Permalink: ../1401256026003-5805199.post@n5.nabble.com/
Also on: postgresql.org/message-id/1401256026003-5805199.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mock@fakebelieve.org
Subject: Re: Unquoted column names fold to lower case
In-Reply-To: <1401256026003-5805199.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox