Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 28 Aug 2006 13:28:34 -0400
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
- Follow-Ups:
- Re: Precision of data types and functions
- From: Scott Marlowe
- Re: Precision of data types and functions
- From: Douglas McNaught
- Re: Precision of data types and functions
- Prev by Date: Can't see what's wrong with this function?
- Next by Date: Re: Can't see what's wrong with this function?
- Previous by thread: Can't see what's wrong with this function?
- Next by thread: Re: Precision of data types and functions
- Indexes: