subject:"\[SQL\] Data Type precision"

Re: [SQL] Data Type precision

2000-09-26 Thread Jie Liang

Hi, there, You can use function: urldb=# select round(234.356534,2); round 234.36 (1 row) Jerome Raupach wrote: > CREATE TABLE TR (f1 FLOAT4, f2 INT4, f3 INT4) ; > > UPDATE TR SET f1=f2/f3::FLOAT4 ; > > f1 -> xx,xx - but I want f1 -> xx,xx. > (6,6)

Re: [SQL] Data Type precision

2000-09-26 Thread Karel Zak

/* * Karel Zak * [EMAIL PROTECTED] * 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:

[SQL] Data Type precision

2000-09-26 Thread Jerome Raupach

CREATE TABLE TR (f1 FLOAT4, f2 INT4, f3 INT4) ; UPDATE TR SET f1=f2/f3::FLOAT4 ; f1 -> xx,xx - but I want f1 -> xx,xx. (6,6) (6,2) anybody can help me ? Thanks. Jerome.