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

Re: case sensitive identifiers in 7.3.4

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Dana Hudes <dhudes(at)tcp-ip(dot)info>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: case sensitive identifiers in 7.3.4
Date: 2004-07-08 05:32:21
Message-ID: 200407080732.21671.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Dana Hudes wrote:
> The documentation clearly states in section "1.1.1 Identifiers and
> Keywords" that "Identifier and key word names are case insensitive".
> It goes on to give an example where a column name is used in lower
> case and in upper case or any mixture.
>
> I have found that the actual implemented behavior is not
> in conformance with the above. It can be demonstrated in psql
> if you create a column whose name is mixed case , e.g. "DocRoot" in
> table "websites" that
> 	select "DocRoot" from "websites";
> works and that
> 	select "docroot" from "websites" does not.

Reread the above section up to the very end and then come back.


In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2004-07-08 05:33:11
Subject: Re: Can't join on null values
Previous:From: Dana HudesDate: 2004-07-08 04:29:38
Subject: case sensitive identifiers in 7.3.4

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