Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)

From: darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain)
To: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
Cc: "'Philip Warner'" <pjw(at)rhyme(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)
Date: 2001-04-03 11:06:43
Message-ID: 20010403110643.5D20B1A7B@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at){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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2001-04-03 12:10:40 Re: capitalized sql (was: Re: Changing the default value of an inherited column)
Previous Message Tatsuo Ishii 2001-04-03 10:58:07 Re: Third call for platform testing