Re: integer instead of 'double precision'? - Mailing list pgsql-general

Henry,

 

Does this suit your need?

 

select 1/3::float as answer;

      answer      

-------------------

0.333333333333333

(1 row)

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Henry Drexler
Sent: Friday, September 09, 2011 10:42 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] integer instead of 'double precision'?

 

take any table and run

 

Query

---------------------

select

1/3

from

storage

limit 1

 

 

Result

---------------------

?column?

integer

0

 

 

Expected Result

---------------------

?column?

double precision

0.33333...

 

 

 

Question

---------------------

Since there is no column type to begin with as this is a made-up column, shouldn't postgres know it is double precision due to the remainder?

 

I thought perhaps I could cast it as double precision as noted on http://www.postgresql.org/docs/8.3/interactive/sql-expressions.html

 

though doing the following:

 

select

float8(1/3)

from

storage

limit 1

 

results in:

 

float8

double precision

0

 

 

any ideas on how to get this type of a manufactured column (not sure the right term for it) to show the double precision result?