table and column name

From: "wisan watcharinporn" <maccran(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: table and column name
Date: 2004-09-13 13:02:34
Message-ID: BAY18-F17gln49iLGBU00043b4c@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

i think it not bug but it not correct at all

i create table with command
create table helloWorld (....) <-- it create table helloworld not
helloWorld, i hope it be create helloWorld
create table "helloWorld" (....) <-- ok it create table helloWorld

in the same to create column name

because in style i prefer to give name helloWorld more than hello_world it
save more
character (and in java style) and in query i like to use

select numberOfTeam from teamInOurSchool where studentAge >
maxAgeOfSmallChild;

more than
select number_of_team from team_in_our_school where student_age >
max_age_of_small_child;

or
select 'numberOfTeam' from 'teamInOurSchool' where 'studentAge' >
'maxAgeOfSmallChild';

for more 3000~5000 query i write in program i think it more save and easy to
read
thank you

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-09-13 14:11:20 Re: PosgreSQL is crashing with a signal 11 - Bug?
Previous Message Thomas Niemeier 2004-09-13 11:22:11 Problem cocatenating String (||)