Henry Drexler <alonup8tb@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
