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

Simple sql question

From: "Tore Lukashaugen" <tore(at)lukashaugen(dot)freeserve(dot)co(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Simple sql question
Date: 2007-10-03 18:01:57
Message-ID: fe0lfo$1ov9$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-novice
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?

Appreciate your help.

Tore 



Responses

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2007-10-03 18:35:55
Subject: Re: Simple sql question
Previous:From: Michael GlaesemannDate: 2007-10-02 23:21:25
Subject: Re: Implicit btree index from unique constraint versus explicit btree index

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