Re: Fixed-point scalars?

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