[SQL] date infinity

[Ferruccio Zamuner]

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