On Mon, Jun 29, 2009 at 09:54:04AM -0700, Jonathan Leffler wrote: > On Mon, Jun 29, 2009 at 9:23 AM, David Fetter <da...@fetter.org> wrote: > > > On Mon, Jun 29, 2009 at 04:26:30PM +0100, Tim Bunce wrote: > > > Oracle is one of those databases that uppercases (unquoted) > > > names. That's perfectly valid behaviour - though it can be a > > > major pain. > > > > It's not just valid behavior. It's mandated by the SQL standard > > :( > > > The standard also says that these are 3 separate tables: > > CREATE TABLE "foo" (...); CREATE TABLE "FOO" (...); CREATE TABLE > "Foo" (...);
Yes, but we were discussing case-folding behavior in unquoted identifiers. The standard is clear on this, an it mandates fold-to-upper. It's the only place I know of where PostgreSQL intentionally violates the standard, that violation being that it folds to lower instead. Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate