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.
> 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.
<snip />
> The types decimal and numeric are equivalent. Both types are part
> of the SQL standard.
The PostgreSQL are quite extensive and helpful.
Michael Glaesemann
grzm seespotcode net