Bugs: Browse | Submit New | Admin

[#29411] Invalid support for "inifinity" as timestamp (postgresql)

Date:
2011-10-28 09:59
Priority:
3
Submitted By:
Herwin Weststrate (herwinw)
Assigned To:
Nobody (None)
Category:
has patch
State:
Open
Summary:
Invalid support for "inifinity" as timestamp (postgresql)

Detailed description
Postgres has support for timestamps "infinity" and "-infinity"
<http://www.postgresql.org/docs/8.3/interactive/datatype-datetime.html#DATATYPE-DATETIME-SPECIAL-TABLE>, but when
these are retrieved via a query they are converted to `today 00:00:00`. This is an improvement compareed to older version
where something crashed, but still it's not usable.

The attached patch contains a fix for this, but I'm not sure if this is the best way to fix this. Possible other databases
than postgresql have support for infinite timestamps as well, which means the fix should probably move somewhere to
the DBD modules.

Add A Comment: Notepad

Please login


Followup

No Followups Have Been Posted

Attached Files:

Name Description Download
infinity.diff patch with fix Download

Changes:

Field Old Value Date By
File Added5307: infinity.diff2011-10-28 09:59herwinw