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

Re: Simple sql question

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

In response to

pgsql-novice by date

Next:From: Brian HurtDate: 2007-10-03 18:43:43
Subject: Re: Simple sql question
Previous:From: Wright, GeorgeDate: 2007-10-03 18:35:55
Subject: Re: Simple sql question

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