Re: case sensitivity - Mailing list pgsql-bugs

From Tom Lane
Subject Re: case sensitivity
Date
Msg-id 10950.1057520795@sss.pgh.pa.us
Whole thread Raw
In response to Re: case sensitivity  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: case sensitivity  (Shachar Shemesh <psql@shemesh.biz>)
List pgsql-bugs
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> I believe that it would require the identifiers in the following to
> be the same, whereas PostgreSQL would treat them as different.

See also the example and footnote at the end of section 1.1.1 of our
documentation:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
(not sure why the link to the footnote doesn't work in that version, but
the footnote is at the bottom of the page).

There has been some talk of providing an alternate mode in which
unquoted identifiers are folded per spec, but this seems likely to
break enough code that no one has really wanted to do it.  My guess
is that we will remain intentionally non compliant on this point
forever.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: case sensitivity
Next
From: Shachar Shemesh
Date:
Subject: Re: case sensitivity