Received: from svana.org (svana.org [210.9.66.30]) by postgresql.org (Postfix) with ESMTP id 2F2754758DB; Fri, 19 Jul 2002 03:20:57 -0400 (EDT) Received: from kleptog by svana.org with local (Exim 3.12 #1 (Debian)) id 17VS3f-0003Fl-00; Fri, 19 Jul 2002 17:20:11 +1000 Date: Fri, 19 Jul 2002 17:20:11 +1000 From: Martijn van Oosterhout To: stefan@extum.com Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: id and ID in CREATE TABLE Message-ID: <20020719172011.A12484@svana.org> Reply-To: Martijn van Oosterhout Mail-Followup-To: stefan@extum.com, pgsql-sql@postgresql.org, pgsql-general@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from stefan@extum.com on Sat, Jul 20, 2002 at 10:39:52AM +0300 X-Archive-Number: 200207/1159 X-Sequence-Number: 27646 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 http://svana.org/kleptog/ > There are 10 kinds of people in the world, those that can do binary > arithmetic and those that can't.