You can't use a floating point representation for money! If the "real" type is
implemented internally as a C double or float, its not suitable for money.
This is due to the way floating point numbers are stored in hardware. Money should
only be done with integral types. Use fixed point arithmeti
excuse me... I have a question...
I found another data types like "numeric" and
"decimal".
but the "real" type is the only that could accept
14 and 2 decimals... the othes (numeric or decimal does not)... I would like to
know how is the precision using the "real" data type
thanks
Meib
You may use type real? -- Banghe
Meibell Contreras wrote:
hello; Anyone
knows if postgres has a bigger data type than money...when
you use this; (not with dollar definition); the money data type is not
enough... graciasMeibell
hello;
Anyone knows if postgres has a bigger data type
than money...
when you use this; (not with dollar definition);
the money data type is not enough...
gracias
Meibell
When using the copy command to bulk load data, will it update the indexes,
or do you have to explicitly drop and recreate the indexes?
Thanks,
Tim
