| 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: | Whole Thread | Raw Message | 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
| 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 |