Re: Data Type precision

/* ----------------
* Karel Zak * zakkr(at)zf(dot)jcu(dot)cz * http://home.zf.jcu.cz/~zakkr/
* C, PostgreSQL, PHP, WWW, http://docs.linux.cz
* ----------------
*/

On Tue, 26 Sep 2000, Jerome Raupach wrote:

> CREATE TABLE TR (f1 FLOAT4, f2 INT4, f3 INT4) ;
>
> UPDATE TR SET f1=f2/f3::FLOAT4 ;
>
> f1 -> xxxxxx,xxxxxx - but I want f1 -> xxxxxx,xx.
> (6,6) (6,2)

See formatting functions in docs:

test=# SELECT TO_CHAR( 123456.123456, '999999.99')::float8;
?column?
-----------
123456.12
(1 row)

Note, really float4 with 8 places (6,2)?

test=# select '123456.12'::float4;
?column?
----------
123456
(1 row)

test=# select '1234.12'::float4;
?column?
----------
1234.12
(1 row)

test=# select '123456.12'::float8;
?column?
-----------
123456.12
(1 row)

Karel