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