Re: case sensitivity

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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