Re: [BUGS] BUG #8355: PL/Python 3 can't convert infinity to PostgreSQL's value
I wrote:
... But it seems like maybe we had better cover the
following cases that we do not cover today:
inf
+inf
-inf
+Infinity
I've committed a patch that makes sure float4in and float8in accept
these spellings even when the underlying strtod(3) function does not.
However, it turns out that this doesn't fix your test case on my HPUX
box, and I'm betting that it won't help on Windows either, because
it's actually Python that's failing. You can reproduce the failure
without any Postgres code involved at all:
$ python
Python 2.5.1 (r251:54863, Jul 12 2007, 23:25:33)
[GCC 2.95.3 20010315 (release)] on hp-ux10
Type help, copyright, credits or license for more information.
a = float('inf')
Traceback (most recent call last):
File stdin, line 1, in module
ValueError: invalid literal for float(): inf
Now, I seriously doubt that the Python guys will give a darn about
a 15-year-old version of HPUX, but if you can reproduce the above
on your Windows machine, I'd suggest filing a bug about it with them.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.
The following bug has been logged on the website: Bug reference: 8361 Logged by: Jan-Benedict Glaw Email address: jbg...@lug-owl.de PostgreSQL version: Unsupported/Unknown Operating system: Debian unstable/experimental Description: Hi! I just found intervals that are shown with more than 24 hours in the `hours' field. Their overall shown value matches EXTRACT (expoch from ), but the printed value looks bogus: buildmaster= select avg(lastbuild_same) from test_values ; avg --- 1 day 26:16:18.678927 (1 row) Notice the 26 there. It's actually 2 days 2h 16min 18sec. Short SQL snippet can be found at http://lug-owl.de/~jbglaw/intervals_not_printed_correctly.sql Would be nice if somebody would test this with further PostgreSQL versions and specifically with the most recent development branch. Thanks, Jan-Benedict -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #8361: 9.3~beta2-2: Wrong `interval' format with aggregate functions.
jbg...@lug-owl.de writes: I just found intervals that are shown with more than 24 hours in the `hours' field. This is not erroneous. 24 hours is not necessarily equivalent to 1 day, so the interval type doesn't automatically transpose one to the other. If you want that sort of conversion, see the justify_days(), justify_hours(), and justify_interval() functions. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
