-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
PG 8.1.5
The closed-source RDBMS that we are hoping to archive on PostgreSQL
8.1.5 has fixed-point scalars, where the data is *stored* as a plain
old scalar, but is run-time *interpreted* as having a decimal point.
For example:
SMALLINT(2)
INTEGER(2)
BIGINT(2)
We use INTEGER(2) *extensively* for monetary values that won't
exceed $21,474,836.47, and BIGINT(2) for those times where it might.
This is very useful since integer arithmetic is so fast, and you
know the field will always be 4 bytes.
Are these data-types not in PG, or am I missing something?
Also, how do you calculate the size of a NUMERIC?
Lastly, I know they are the same, but which is the
"preferred/standard" type: NUMERIC or DECIMAL?
Thanks
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFFNXl0S9HxQb37XmcRAsoiAJ0f8UGrYRm8eE3eX6EJYDJn6riV1wCfScHC
J7l8E1S7WS++1wDxW/9k6b0=
=zhgS
-----END PGP SIGNATURE-----