-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10/17/06 22:14, Michael Glaesemann wrote: > > On Oct 18, 2006, at 9:46 AM, Ron Johnson wrote: > >> SMALLINT(2) >> INTEGER(2) >> BIGINT(2) > >> Are these data-types not in PG, or am I missing something? > > > http://www.postgresql.org/docs/current/interactive/datatype.html#DATATYPE-NUMERIC > > > The docs list 2 byte, 4 byte, and 8 byte integer types. Yes, I saw that, but did not know if other references were tucked away on a different page. >> 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? > > Later on, same page: > > http://www.postgresql.org/docs/current/interactive/datatype.html#DATATYPE-NUMERIC-DECIMAL > > >> The actual storage requirement is two bytes for each group of four >> decimal digits, plus eight bytes overhead. Oh, now I see it. My eyes must have glazed over that paragraph. Eight bytes overhead? *Wow*. Combined with the lack of TINYINT, jumping from 4 bytes (which is what the current RDBMS uses) to 8+2 or 8+4 for money values is really going to increase record sizes. > <snip /> > >> The types decimal and numeric are equivalent. Knew that. > Both types are part of >> the SQL standard. Didn't know if one was out of fashion or not. > The PostgreSQL are quite extensive and helpful. - -- 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) iD8DBQFFNgANS9HxQb37XmcRAkzEAJ9o/Hnv2u2Cu1G9Dny19T1V9hdwogCgjy4O zwALgdVyKqUohLKbLiuvHww= =UYQc -----END PGP SIGNATURE-----
