Re: [SQL] Division in Postgre

2005-05-01 Thread hatuan
Thank you - Original Message - From: "Stephan Szabo" <[EMAIL PROTECTED]> To: "tuan" <[EMAIL PROTECTED]> Cc: Sent: Saturday, April 30, 2005 10:56 AM Subject: Re: [SQL] Division in Postgre > On Sun, 24 Apr 2005, tuan wrote: > > > In sql serv

Re: [SQL] Division in Postgre

2005-04-29 Thread Stephan Szabo
On Sun, 24 Apr 2005, tuan wrote: > In sql server my division select cast(3 as float)/10 is 0.299. > 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_digi

[SQL] Division in Postgre

2005-04-29 Thread tuan
In sql server my division select cast(3 as float)/10 is 0.299. 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 ---(end of broadcast)--- TIP 5: Have you checked our extensi