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