Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2007-10-05 23:33:01
Subject: Re: timestamp interval issue
Previous:From: Valentin GjorgjioskiDate: 2007-10-05 23:08:39
Subject: Re: timestamp interval issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group