On Sat, 22 Nov 2003, Rajesh Kumar Mallah wrote:
> How come numeric(10,2) accepting value 10.011 and truncating the .001
> part ? Shudnt' it be complaining , i am not sure.
AFAICS, the spec says that implementation-defined rounding or truncation
occurs if least significant digits would be lost.
Hi,
How come numeric(10,2) accepting value 10.011 and truncating the .001
part ? Shudnt' it be complaining , i am not sure.
Regds
Mallah.
tradein_clients=# CREATE TABLE t_a ( a numeric (10,2) );
CREATE TABLE
tradein_clients=#
tradein_clients=#
tradein_clients=# \d t_a
Table "publ
