Re: add column sillyness

Bruce Momjian wrote:
> "I'm tired of MySQL being beaten up by the PostgreSQL guys. I am going
> to fight back! Where is my sword?"

Carefull Bruce. The MySQL sword is razor sharp only on one side and is
missing the handle! But if you succeed to pull it out without cutting
off your fingers, it'll cut everything else to fit without warning ...
if you want that cut or not.

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
>>
>> 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
>>
>> Regards
>> Tom
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>> message can get through to the mailing list cleanly
>>
>

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #