Precision of data types and functions

From: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Precision of data types and functions
Date: 2006-08-28 17:28:34
Message-ID: F8E84F0F56445B4CB39E019EF67DACBA21F633@exchsrvr.winemantech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm considering migrating our MySQL 4.1 database (barf!) to PostgreSQL 8
or MySQL 5.

The guy who originally designed the system made all the number data
FLOATs, even for currency items. Unsurprisingly, we've noticed math
errors resulting from some of the aggregate functions. I've learned
MySQL 5 stores numbers with the DECIMAL data type as text strings, and
does math at 64-bit precision. Where can I find information about how
precise PostgreSQL 8 math is?

--
Brandon Aiken
CS/IT Systems Engineer

Responses

Browse pgsql-general by date

  From Date Subject
Next Message josh hes. 2006-08-28 17:49:20 transaction isolation level
Previous Message Harpreet Dhaliwal 2006-08-28 17:27:04 Re: Perl language creation failed