Re: BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value

grv87(at)yandex(dot)ru writes:
> PL/Python can't convert Python's float with infinity value to PostgreSQL's
> float.
> The reason is that Python's standard representation of infinity is 'inf'
> ('Infinity' is accepted as well), but PostgreSQL's representation is
> 'Infinity' only.

Hmm, I was about to contradict you, because it works fine on my Linux
and OS X machines:

regression=# select 'inf'::float8;
float8
----------
Infinity
(1 row)

but further experimentation says that this doesn't work on my ancient
HPUX box; and you're complaining about Windows. So what we've got here
is a platform dependency in the behavior of strtod(). I don't think
we can promise to hide all such dependencies, but maybe it'd be a good
idea to take care of this particular one.

regards, tom lane