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