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