On 03.10.2007 20:56 Tore Lukashaugen wrote:
> Indeed it does, thanks very much guys!
>
> ----- Original Message ----- From: "Wright, George"
> <George.Wright@infimatic.com>
> To: "Tore Lukashaugen" <tore@lukashaugen.freeserve.co.uk>;
> <pgsql-novice@postgresql.org>
> Sent: Wednesday, October 03, 2007 7:35 PM
> Subject: Re: [NOVICE] Simple sql question
>
>
> select cast (col1 as float) / cast (col2 as float) from test;
>
quick and dirty ...
select col1 / (col2+0.0) from test;
gives 0.5