Re: Datetime operators (was: Re: [SQL] Another Date question)

<kaiq@realtyideas.com> 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