From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | Tore Lukashaugen <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Simple sql question |
Date: | 2007-10-03 18:38:24 |
Message-ID: | 4703E1A0.6080801@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tore Lukashaugen wrote:
> Hello,
>
> I am new to Postgres and have an embarassingly simple question. I am running
> v8.2 on Windows Vista although I don't think that has any bearing on the
> answer.
>
> create table test (col1 int, col2 int)
> insert into test values (1,2);
> select col1/col2 from test....yields 0 not 0.5 - why?
>
> Presumably this is because both col1 and col2 are ints and the output needs
> to be casted somehow? Or is it because PGAdmin's SQL interface does not by
> default show the decimal places of output?
Cast one of the values to float first. Then, your result will be as
expected.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Brian Hurt | 2007-10-03 18:43:43 | Re: Simple sql question |
Previous Message | Wright, George | 2007-10-03 18:35:55 | Re: Simple sql question |