integer instead of 'double precision'?

Поиск
Список
Период
Сортировка
От Henry Drexler
Тема integer instead of 'double precision'?
Дата
Msg-id CAAtgU9QHTCei4Z3N2QTdfokdON50=yWkK4iTUQTicxgFY9-inQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: integer instead of 'double precision'?
Re: integer instead of 'double precision'?
Re: integer instead of 'double precision'?
Список pgsql-general
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?

В списке pgsql-general по дате отправления:

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: PSQLRestore
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: integer instead of 'double precision'?