Re: Simple sql question

From: Valentin Gjorgjioski <tinodj(at)mt(dot)net(dot)mk>
To: pgsql-novice(at)postgresql(dot)org
Cc: Tore Lukashaugen <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk>
Subject: Re: Simple sql question
Date: 2007-10-05 23:16:47
Message-ID: 4706C5DF.4000008@mt.net.mk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lonni J Friedman 2007-10-05 23:33:01 Re: timestamp interval issue
Previous Message Valentin Gjorgjioski 2007-10-05 23:08:39 Re: timestamp interval issue