[Pypgsql-devel] [ pypgsql-Patches-773489 ] Add support for 'infinity' in query-results

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Patches item #773489, was opened at 2003-07-18 04:41
Message generated for change (Comment added) made by ballie01
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=316528&aid=773489&group_id=16528

Category: None
Group: None
>Status: Pending
>Resolution: Fixed
Priority: 5
Submitted By: Thomas Langås (tlan)
Assigned to: Billy G. Allie (ballie01)
Summary: Add support for 'infinity' in query-results

Initial Comment:
Today (tested with your 2.4-release, as well), it crashes 
with an exception when DATETIME-fields 
contains 'infinity'.

On line 800 in PgSQL.py add:
                if value in ('infinity', '+infinity', '-infinity'):
                    fake_infinity = '9999-12-13 23:59:59'    # 
fake infinity      
                    if value[0] == '-':
                        value = '-' + fake_infinity
                    else:
                        value = fake_infinity

Maybe you want to add some sort of constant 
somewhere or something, so that one can do if 
date=&lt;constant&gt; to check for infinity, so that one can 
change the date/time at a later date,without breaking 
programs.

----------------------------------------------------------------------

>Comment By: Billy G. Allie (ballie01)
Date: 2005-02-20 00:11

Message:
Logged In: YES 
user_id=8500

Applied patch.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=316528&aid=773489&group_id=16528