Bug #463: Make 'infinity' work with type 'date' - Mailing list pgsql-bugs

Dax Kelson (dax@gurulabs.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Make 'infinity' work with type 'date'

Long Description
CREATE TABLE test ( somedate date NOT NULL DEFAULT 'infinity' );
ERROR: Unrecognized date external representation of 'infinity'

But,

CREATE TABLE test ( somedate timestamp NOT NULL DEFAULT 'infinity' );

Works.


Sample Code


No file was uploaded with this report