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