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