Postgres Pro
Downloads
Home   >   mailing lists

Re: date infinity - Mailing list pgsql-sql

From Tom Lane
Subject Re: date infinity
Date
Msg-id 11941.978423629@sss.pgh.pa.us
Whole thread Raw
In response to date infinity  (Ferruccio Zamuner <nonsolosoft@diff.org>)
List pgsql-sql
Tree view 
Ferruccio Zamuner <nonsolosoft@diff.org> writes:
>   expire date default 'infinity');
> ERROR:  Unrecognized date external representation 'infinity'

infinity is a timestamp (or datetime) feature, not a date feature.
        regards, tom lane

pgsql-sql by date:

Previous
From: Ferruccio Zamuner
Date:
Subject: date infinity
Next
From: "Francis Solomon"
Date:
Subject: RE: Date/Time problem -(((