Dax Kelson ([EMAIL PROTECTED]) 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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to