Make sure float4in/float8in accept all standard spellings of "infinity".
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 3 Aug 2013 16:40:06 +0000 (12:40 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 3 Aug 2013 16:40:55 +0000 (12:40 -0400)
commitde27c2985f81801c1f9198159d379a036d472943
tree2afae7cd33d6af70dbd84ffdd578254d64e0c714
parent1bd148c6aa14dffbb9b21e3db0192b42ea8774a6
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.
src/backend/utils/adt/float.c