Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA10848; Fri, 3 Dec 1999 17:38:47 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id RAA03221; Fri, 3 Dec 1999 17:35:58 -0500 (EST) To: kaiq@realtyideas.com cc: Thomas Lockhart , Karel Zak - Zakkr , Andy Lewis , pgsql-hackers , pgsql-sql Subject: Re: Datetime operators (was: Re: [SQL] Another Date question) In-reply-to: Your message of Fri, 3 Dec 1999 13:43:06 -0600 (CST) Date: Fri, 03 Dec 1999 17:35:58 -0500 Message-ID: <3219.944260558@sss.pgh.pa.us> From: Tom Lane writes: > why > create table mymy (mydate datetime default (now() + '60 days'::timespan )); > does not work? I believe :: casts are broken in default expressions in 6.5.*. They are fixed in current sources (which is what Thomas probably tried) --- but in the meantime, that expression will work fine without the cast... regards, tom lane