Re: add column sillyness

On Thu, 11 Dec 2003, Jan Wieck wrote:

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

well, to be perfectly honest, I think everyone drop'd him off of the CC
list, so he never got any of the 'yo, idiot' messages :)


>
>
> 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 #
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>

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