Re: add column sillyness

On Tue, 9 Dec 2003, Ian Barwick wrote:

> 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.

That's why I let that one slip through the proverbial cracks ... figured a
few ppl would have a good chuckle :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664