Bug #463: Make 'infinity' work with type 'date'

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #463: Make 'infinity' work with type 'date'
Date: 2001-09-20 21:25:42
Message-ID: 200109202125.f8KLPgo67558@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dax Kelson (dax(at)gurulabs(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Summerfield 2001-09-20 22:40:01 Re: CVS rejected me
Previous Message pgsql-bugs 2001-09-20 18:04:49 Bug #462: bug in ODBC interface in unix environment