Re: SELECT problem

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