<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