hello all,

this is the output as asked by Tom Lane.

test8=> \set VERBOSITY verbose
test8=> SELECT 'infinity'::float4;
float4
----------
Infinity
(1 row)

test8=> SELECT 'infinity'::float4;
ERROR: 22P02: invalid input syntax for type real: "infinity"
LOCATION: float4in, float.c:330

Following what Michael Fuhr reported about bug fix in Solaris 10 I'll try to
build and test asap on a Ultra 250 dual 400MHz CPU installed with Solaris 10 beta.
Anyways I can't do it before Aug 23 . As soon as I build I'll run the test and
post the results here.

Andre

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Tue, Aug 10, 2004 at 12:17:47PM +0200, andrea.martano (AT) lighthousetc (DOT) net wrote:
[snip]

Perhaps PostgreSQL doesn't handle a longstanding misbehavior of
strtod() on Solaris: when passed "Infinity" or its equivalent,
strtod() sets endptr to point one character beyond the terminating
null character instead of to the null character itself. I asked
about this today in comp.unix.solaris and was told that it's a bug
that will be fixed in Solaris 10. Here's a similar report from
over nine years ago:

http://groups.google.com/groups?&thr...e.berkeley.edu

The thread I started hasn't showed up at groups.google.com yet, but
I think this link will eventually point to it:

http://groups.google.com/groups?&thr...ensional .com

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster