From: Martijn van Oosterhout <kleptog@svana.org>
To: stefan@extum.com
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: id and ID in CREATE TABLE
Date: Fri, 19 Jul 2002 17:20:11 +1000
Message-ID: <20020719172011.A12484@svana.org> (raw)
In-Reply-To: <Pine.LNX.4.44.0207201035520.3427-100000@extum.com>
References: <Pine.LNX.4.44.0207201002310.3355-100000@extum.com>
<Pine.LNX.4.44.0207201035520.3427-100000@extum.com>
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 );
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
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: kleptog@svana.org, stefan@extum.com, pgsql-general@postgresql.org
Subject: Re: id and ID in CREATE TABLE
In-Reply-To: <20020719172011.A12484@svana.org>
* 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