Division in Postgre

From: "tuan" <atuan_h(at)hotmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Division in Postgre
Date: 2005-04-24 09:18:36
Message-ID: BAY12-DAV1034161CFA2DABEF05BE2A972F0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander Vlasenko 2005-04-24 16:38:30 unsubscribe
Previous Message Mischa Sandberg 2005-04-23 23:57:05 Re: weird SQL statement question