Hello In PostgreSQL 7.2/7.1:
template1=# select text(2.000::numeric); text ------ 2 (1 row) In 7.3: template1=# select text(2.000::numeric); text ------- 2.000 (1 row) The text(numeric) function doesn't round numbers. :( This is bug or feature? :) -Sygma ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster