This is for PostgreSQL 7.4.6...
On Tuesday October 26 2004 7:31, Ed L. wrote:
> $uname
> HP-UX ... B.11.23 U ia64 1562128462 unlimited-user license
>
> $more ./regression.diffs
> *** ./expected/float8.out Thu Sep 25 01:58:06 2003
> --- ./results/float8.out Tue Oct 26 20:28:09 2004
> ***************
> *** 249,255 ****
> SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ERROR: type "double precision" value out of range: overflow
> SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
> ! ERROR: result is out of range
> SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
> ERROR: cannot take logarithm of zero
> SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
> --- 249,255 ----
> SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
> ERROR: type "double precision" value out of range: overflow
> SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
> ! ERROR: type "double precision" value out of range: overflow
> SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
> ERROR: cannot take logarithm of zero
> SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
>
> ======================================================================
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
