Re: Datetime operators (was: Re: [SQL] Another Date question) - Mailing list pgsql-sql

From Thomas Lockhart
Subject Re: Datetime operators (was: Re: [SQL] Another Date question)
Date
Msg-id 384822B5.835F309A@alumni.caltech.edu
Whole thread Raw
In response to Re: Datetime operators (was: Re: [SQL] Another Date question)  (<kaiq@realtyideas.com>)
List pgsql-sql
> 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


pgsql-sql by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Datetime operators (was: Re: [SQL] Another Date question)
Next
From: Tom Lane
Date:
Subject: Re: Datetime operators (was: Re: [SQL] Another Date question)