Re: SELECT problem - Mailing list pgsql-general

From Neil Conway
Subject Re: SELECT problem
Date
Msg-id 20020622182108.5636694d.nconway@klamath.dyndns.org
Whole thread Raw
In response to Re: SELECT problem  (Andrew Sullivan <andrew@libertyrms.info>)
List pgsql-general
On Fri, 21 Jun 2002 08:25:54 -0400
"Andrew Sullivan" <andrew@libertyrms.info> wrote:
> On Fri, Jun 21, 2002 at 12:24:02PM +0100, David Goodenough wrote:
>
> > Well yes that works, but why?  In every book I have ever read on SQL
> > the column names are not in quotes, and the other DB I use regularly
> > (IBM DB/2) does not require the column names in quotes, and actually
> > does not recognise the column names if they are in quotes?
>
> PostgreSQL is actually contrary to the standard here, in that it
> makes everyting lower-case.

Which part of which standard is PostgreSQL contrary to?

(You may well be right -- it's just that I couldn't see anything
in SQL99 after a cursory look.)

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Creating a user fails
Next
From: Devrim GUNDUZ
Date:
Subject: Celebration of 25th year?