Thread: Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)
Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)
From
Zeugswetter Andreas SB
Date:
> will get dumped as: > > CREATE TABLE "c5" ( > "f1" integer NOT NULL, > "f3" integer > ) > inherits ("p3_def1"); As an aside answer without considerable importance: Why do people tend to write SQL keywords in all capitals ? PostgreSQL converts everything to lower case (which I like). So why not output lowercase ? Above example even mixes case, why ? Andreas
Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)
From
darcy@druid.net (D'Arcy J.M. Cain)
Date:
Thus spake Zeugswetter Andreas SB > > will get dumped as: > > > > CREATE TABLE "c5" ( > > "f1" integer NOT NULL, > > "f3" integer > > ) > > inherits ("p3_def1"); > > As an aside answer without considerable importance: > > Why do people tend to write SQL keywords in all capitals ? > PostgreSQL converts everything to lower case (which I like). > So why not output lowercase ? Above example even mixes > case, why ? I do it for maintenance purposes. All of my code uses caps for keywords so that I can find them without getting them confused with language constructs and variables. -- D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.