Re: [SQL] date infinity

2001-01-02 Thread Tom Lane
Ferruccio Zamuner <[EMAIL PROTECTED]> 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

[SQL] date infinity

2001-01-01 Thread 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 d