On 6/25/2010 4:22 AM, John Gage wrote:
There are features, are there not, that Postgres has that MySQL does not
have?

Yes, a big one would be data integrity. Most people would not consider data integrity an optional feature in a DBMS, but apparently MySQL does. Try this in MySQL:

create table t1 (f1 varchar(10))
insert into t1 values('this is a long string')
select * from t1

When I do this on a version 5.0.44 MySQL DB (the latest I have conveniently available), MySQL processes the insert without complaint, silently truncating the string to "this is a". Why people aren't bothered by this is beyond me.

--
Guy Rouillier

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to