Re: [HACKERS] Auto selection of internal representation for integer NUMERIC

2006-07-03 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > In particular, this is useful for oracle users. Oracle recommends to use > NUMBER(n, p) for all the case where numerics are required. So they try to > use NUMERIC on PostgreSQL instead of NUMBER. But NUMERIC is not the best > alternative to a short int

[HACKERS] Auto selection of internal representation for integer NUMERIC

2006-07-03 Thread ITAGAKI Takahiro
Hi Hackers, I think about mapping NUMERIC(n) to fixed size integers corresponding to n: - n < 4 to int2 - 5 <= n < 9 to int4 - 10 <= n < 18 to int8 - 19 <= n to original numeric NUMERIC is not so efficient datatypes compared to fixed size integers. If the auto selection is aval