-----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-----