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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kaiq(at)realtyideas(dot)com
Cc: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>, Andy Lewis <alewis(at)roundnoon(dot)com>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, pgsql-sql <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: Datetime operators (was: Re: [SQL] Another Date question)
Date: 1999-12-03 22:35:58
Message-ID: 3219.944260558@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

<kaiq(at)realtyideas(dot)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

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-12-03 23:33:04 Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Previous Message Jeff Hoffmann 1999-12-03 21:57:39 Re: [HACKERS] Re: Geometric Data Type in PostgreSQL

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-12-03 23:00:32 Re: [SQL] Wierd stuff
Previous Message kaiq 1999-12-03 21:01:51 Re: Datetime operators (was: Re: [SQL] Another Date question)