From: stefan@extum.com
To: Martijn van Oosterhout <kleptog@svana.org>
Cc: pgsql-sql@postgresql.org, <pgsql-general@postgresql.org>
Subject: Re: id and ID in CREATE TABLE
Date: Sat, 20 Jul 2002 14:33:22 +0300 (EEST)
Message-ID: <Pine.LNX.4.44.0207201246180.3615-100000@extum.com> (raw)
In-Reply-To: <20020719172011.A12484@svana.org>
Thanks all for comments. In Oracle and DB2 as far as I know the upper case
column names are used when you have no columns quoted.. Indeed it is
recommended to use lower cases to
avoid mistakes and confusion during porting. Is that right ?
But anyway this is not so important, but why upper cases are bad ?
Why then Oracle , IBM is using them and why the SQL standard is not
changed ?
stefan
On Fri, 19 Jul 2002, Martijn van Oosterhout wrote:
> On Sat, Jul 20, 2002 at 10:39:52AM +0300, stefan@extum.com wrote:
> >
> > I forgot about "" Sorry. So if I would use names quoted then my questions
> > are obsolete. Except one:
> >
> > So actually the only strange part would be PostgreSQL is folding to lower
> > cases a column name ...
>
> [snip]
>
> > Why is like this ? Why not letting them upper case if they are not quoted
> > ?
>
> I think it's because many people think that uppercase column names suck. And
> I agree with them. If you follow the given advice (either always quote
> column names or never) then not only will your program work, it's will be
> completely portable.
>
> So, if you'd used your CREATE TABLE statememnt below, you wouldn't have had
> this problem.
>
> > > CREATE TABLE ttt (
> > >
> > > ID int2,
> > > name text );
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: stefan@extum.com, kleptog@svana.org, pgsql-general@postgresql.org
Subject: Re: id and ID in CREATE TABLE
In-Reply-To: <Pine.LNX.4.44.0207201246180.3615-100000@extum.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox