Re: rationale behind quotes for camel case?

On Tue, Jun 28, 2011 at 04:00:42AM -0700, John R Pierce wrote:
> capitals (probably reflecting its 1980s IBM origins), but PG decided
> a long time ago to default to lower case, since the final result has
> the same effect.

Well, it _sort of_ has the same effect.  In a traditional SQL
environment, if you use TABLENAME and "TABLENAME", they're equivalent,
but tablename and "TABLENAME" are not.  In PostgreSQL, that doesn't
work: tablename and "tablename" are equivalent instead.  This
sometimes bites people when moving to Postgres, because their
identifier quoting hasn't been consistent in their application.

A

--
Andrew Sullivan
ajs@anvilwalrusden.com