On 03.10.2007 20:56 Tore Lukashaugen wrote:
> Indeed it does, thanks very much guys!
>
> ----- Original Message ----- From: "Wright, George"
> <George(dot)Wright(at)infimatic(dot)com>
> To: "Tore Lukashaugen" <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk>;
> <pgsql-novice(at)postgresql(dot)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