Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group