/* ----------------* Karel Zak * zakkr@zf.jcu.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