Why numeric(2) is not casted to integer automatically ?
Because it would lose data, eg '4.4' being rounded to 4.
create temp table test ( test numeric(2));
insert into test values (0.5);
select * from test
returns
1
I'm really confused now.
I tought that numeric(2) can store only integer data, without decimal
points.
Can you give example how numeric(2) -> integer conversion can lose data,
please.
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
