Received: from tnt.diff.org ([62.98.67.121]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0287UL57547 for ; Tue, 2 Jan 2001 03:07:34 -0500 (EST) (envelope-from nonsolosoft@diff.org) Received: (from fer@localhost) by tnt.diff.org (8.11.1/8.9.3) id f01NtCp13928; Tue, 2 Jan 2001 00:55:12 +0100 (CET) (envelope-from nonsolosoft@diff.org) Date: Tue, 2 Jan 2001 00:55:12 +0100 (CET) Message-Id: <200101012355.f01NtCp13928@tnt.diff.org> X-Authentication-Warning: tnt.diff.org: fer set sender to nonsolosoft@diff.org using -f From: Ferruccio Zamuner To: pgsql-sql@postgresql.org Subject: date infinity X-Archive-Number: 200101/10 X-Sequence-Number: 671 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?