Thread: date infinity

Hi,

I've not found, as reported into postgresql docs, 'infinity':

create temp table subscriptions ( id int references people, expire date default 'infinity');
ERROR:  Unrecognized date external representation 'infinity'


Is there someone that knows the new costant name?


From PostgreSQL docs:
http://localhost/pg7.0.3/postgres/datatype1134.htm
Table 3-14. Postgres Special Date/Time Constants
infinity        Later than other valid times

now and today costants are working.


Bye,            \fer

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