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