Re: case sensitivity
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Shachar Shemesh <psql@shemesh.biz>, pgsql-bugs@postgresql.org
Date: 2003-07-06T19:46:35Z
Lists: 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