Re: Division in Postgre
От | hatuan |
---|---|
Тема | Re: Division in Postgre |
Дата | |
Msg-id | 000b01c54ecd$869ee670$0201a8c0@server обсуждение исходный текст |
Ответ на | Division in Postgre ("tuan" <atuan_h@hotmail.com>) |
Список | pgsql-sql |
Thank you ----- Original Message ----- From: "Stephan Szabo" <sszabo@megazone.bigpanda.com> To: "tuan" <atuan_h@hotmail.com> Cc: <pgsql-sql@postgresql.org> Sent: Saturday, April 30, 2005 10:56 AM Subject: Re: [SQL] Division in Postgre > 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 majordomo@postgresql.org so that your > message can get through to the mailing list cleanly
В списке pgsql-sql по дате отправления: