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