Re: add column sillyness

From: Eric Soroos <eric-psql(at)soroos(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: add column sillyness
Date: 2003-12-09 22:29:31
Message-ID: 286FC7BD-2A97-11D8-8708-0003930F2A6C@soroos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

You forgot space saving storage of floating point numbers:

mysql> create table test(foo int);
Query OK, 0 rows affected (0.51 sec)

mysql> insert into test (foo) values (1.5);
Query OK, 1 row affected (0.42 sec)

mysql> select * from test;
+------+
| foo |
+------+
| 2 |
+------+
1 row in set (0.01 sec)

eric

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Derrick Betts 2003-12-09 22:34:36 Alter Column Position
Previous Message Eric Soroos 2003-12-09 22:25:46 Re: add column sillyness