Postgres Pro
Downloads
Home   >   mailing lists

Re: select 5/2??? - Mailing list pgsql-sql

From missive@frontiernet.net (Lee Harr)
Subject Re: select 5/2???
Date
Msg-id 9pga58$1b7d$2@news.tht.net
Whole thread Raw
In response to select 5/2???  ("guard" <guard@ficnet.net>)
List pgsql-sql
Tree view 
> 
> I run select 5/2  = 2
> who to get "2.5"
> 

integer/integer = integer
float/integer = float
integer/float = float
integer/integer::float = float


test=# SELECT 5.0/2;?column?
----------     2.5
(1 row)

test=# SELECT 5/2::float;?column?
----------      2.5

pgsql-sql by date:

Previous
From: c.ruffin@ieee.org (Chris Ruffin)
Date:
Subject: challenging query
Next
From: "Heather Johnson"
Date:
Subject: Re: [PHP] Need Help!!