| From: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | kaiq(at)realtyideas(dot)com |
| Cc: | Andy Lewis <alewis(at)roundnoon(dot)com>, Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz>, 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 20:06:13 |
| Message-ID: | 384822B5.835F309A@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 1999-12-03 20:15:10 | Re: emacs question |
| Previous Message | Thomas Lockhart | 1999-12-03 20:03:27 | Re: Datetime operators (was: Re: [SQL] Another Date question) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kaiq | 1999-12-03 20:48:09 | Re: Datetime operators (was: Re: [SQL] Another Date question) |
| Previous Message | Thomas Lockhart | 1999-12-03 20:03:27 | Re: Datetime operators (was: Re: [SQL] Another Date question) |