Re: add column sillyness
От | Jan Wieck |
---|---|
Тема | Re: add column sillyness |
Дата | |
Msg-id | 3FD88BD3.3010101@Yahoo.com обсуждение исходный текст |
Ответ на | Re: add column sillyness (Shridhar Daithankar <shridhar_daithankar@myrealbox.com>) |
Ответы |
Re: add column sillyness
|
Список | pgsql-general |
Shridhar Daithankar wrote: > Hi, > > I think it is time to create a pgsql-humour list where such mails can be directed.. > > No point wasting energy answering such questions especially when they do not > appear sincere.. That troll is known for quite some time ... and he doesn't even read these comments any more. I allways wonder what he gains from telling everyone how stupid he is and then walking away. But that's him. Jan > > Thomas Zehetbauer wrote: > >> Why do I have to use FOUR queries to accomplish the same result I can >> get from MySQL with only ONE query: >> >> alter table users add column $ColumnName text; >> alter table users alter column $ColumnName set default ''; >> update users set t_shirt_size='' where $ColumnName is null; >> alter table users alter column $ColumnName set not null; >> >> MySQL is CLEARLY SUPERIOR in terms of >> - usability >> - see above >> - performance >> - uses index for for min()/max() >> - reliability >> - no need to use vacuum >> - no need to dump and restore databases for version upgrade >> - never screwed up any of my databases > > Lucky you..:-) > >> >> I would therefore urgently recommend that >> 1) development of postgresql shall be immediately ceased >> 2) any resources gained thereby (developers, mirrors) shall be donated >> to MySQL >> 3) code produced by the former postgresql developers shall be subject to >> a mandatory peer review before it is included in MySQL > > Shridhar > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
В списке pgsql-general по дате отправления: