Re: case sensitivity

On Mon, Jun 29, 2009 at 09:54:04AM -0700, Jonathan Leffler wrote:
> On Mon, Jun 29, 2009 at 9:23 AM, David Fetter <[email protected]> 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 <[email protected]> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: [email protected]

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate