Re: add column sillyness

On Friday 05 December 2003 21:26, 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

Thanks, I haven't had such a good laugh for days ;-). You might
want to get a new CMOS battery for your motherboard clock though,
April 1st isn't for another 3 1/2 months.

Ian Barwick
barwick(at)gmx(dot)net