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

[SourceForge.net <no...@so...>]

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

Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Thomas Langås (tlan)
Assigned to: Nobody/Anonymous (nobody)
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=<constant> to check for infinity, so that one can 
change the date/time at a later date,without breaking 
programs.

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

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