Make sure float4in/float8in accept all standard spellings of "infinity".

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 221e92f64c6e136e550ec2592aac3ae0d4623209
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2013-08-03T16:40:27Z
Releases: 9.4.0
Make sure float4in/float8in accept all standard spellings of "infinity".

The C99 and POSIX standards require strtod() to accept all these spellings
(case-insensitively): "inf", "+inf", "-inf", "infinity", "+infinity",
"-infinity".  However, pre-C99 systems might accept only some or none of
these, and apparently Windows still doesn't accept "inf".  To avoid
surprising cross-platform behavioral differences, manually check for each
of these spellings if strtod() fails.  We were previously handling just
"infinity" and "-infinity" that way, but since C99 is most of the world
now, it seems likely that applications are expecting all these spellings
to work.

Per bug #8355 from Basil Peace.  It turns out this fix won't actually
resolve his problem, because Python isn't being this careful; but that
doesn't mean we shouldn't be.

Files

PathChange+/−
src/backend/utils/adt/float.c modified +75 −23