Re: integer instead of 'double precision'?

Henry Drexler <alonup8tb@gmail.com> writes:
> [ "1/3" yields zero ]

Yeah, it's an integer division.

> 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:
> float8(1/3)

That's casting the result of the division to float, which is way too
late.  You need to cast one or both inputs to non-integer, for instance

    1.0/3
    1/(3::float8)

etc etc.

            regards, tom lane