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

Поиск
Список
Период
Сортировка
От darcy@druid.net (D'Arcy J.M. Cain)
Тема Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)
Дата
Msg-id 20010403110643.5D20B1A7B@druid.net
обсуждение исходный текст
Ответ на Re: capitalized sql (was: Re: Changing the default valu e of an inherited column)  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список 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@{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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Third call for platform testing
Следующее
От: Philip Warner
Дата:
Сообщение: Re: capitalized sql (was: Re: Changing the default value of an inherited column)