Received: from localhost (IDENT:root@hectic-1.jpl.nasa.gov [128.149.68.203]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA97319; Fri, 3 Dec 1999 16:04:07 -0500 (EST) (envelope-from lockhart@alumni.caltech.edu) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id UAA13928; Fri, 3 Dec 1999 20:06:13 GMT Sender: lockhart@hub.org Message-ID: <384822B5.835F309A@alumni.caltech.edu> Date: Fri, 03 Dec 1999 20:06:13 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: kaiq@realtyideas.com CC: Andy Lewis , Karel Zak - Zakkr , pgsql-hackers , pgsql-sql Subject: Re: Datetime operators (was: Re: [SQL] Another Date question) References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > I feel pain about it :-) because that was what I tried, and then, > since it did not work, I assumed "default" did not accept expressions. No pain here: postgres=> create table mymy (mydate datetime postgres-> default (now() + '60 days'::timespan )); CREATE What version are you running?? - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California