Neil Conway <[EMAIL PROTECTED]> writes: > What number would you like 'Infinity'::float4 and 'Infinity'::float8 > to produce? Is this actually useful functionality?
On an IEEE-spec machine, it's highly useful functionality. +Infinity and -Infinity are special values. BTW the float4out and float8out routines already cope with NANs and infinities, so ISTM the input routines should be able to reverse that. (At the moment you might only be able to get an infinity inside the system as the result of certain math functions.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html