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(at)Yahoo(dot)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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664