3 ms·
Postgres is primarily designed around data integrity. Therefore it does the "right" thing for certain data types. For example, it stores dates and times in ISO
by rpedela 14y ago
Postgres is primarily designed around data integrity. Therefore it does the "right" thing for certain data types. For example, it stores dates and times in ISO 8601 format and converts to UTC. The arbitrary-precision decimal type has a ridiculously high number of maximum digits and decimal places. It is so high that only a very small number of applications would exceed the precision. This is the main reason we are switching from MySQL to Postgres.