On Sun, 24 Apr 2005, tuan wrote:
> 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?
I believe you can control what precision is used in printing the float
results with extra_float_digits. I believe setting it to 2 will give a
0.29... result however it has more 9s than the above.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
