Postgres Pro
Downloads
Home   >   mailing lists

Division in Postgre - Mailing list pgsql-sql

From tuan
Subject Division in Postgre
Date
Msg-id BAY12-DAV1034161CFA2DABEF05BE2A972F0@phx.gbl
Whole thread Raw
Responses Re: Division in Postgre
List pgsql-sql
Tree view 
In sql server my division select cast(3 as float)/10 is 0.29999999999.
But in postgres select cast(3 as float8)/10 is 0.3. How to get result like
sql server?
Thank you. Sorry for my english

pgsql-sql by date:

Previous
From: "Rainer J. H. Brandt"
Date:
Subject: Re: Postgres 8.0.1 on Solaris 10 Sparc: library -lgcc_s: not
Next
From: "Metin Ozisik"
Date:
Subject: Build issues: "-static" builds resulting initdb problems