| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Cc: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: ERROR: operator does not exist: timestamp without time zone + integer |
| Date: | 2019-04-30 22:25:38 |
| Message-ID: | db5a7bad-88a8-4720-37ec-23e014a3532d@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/30/19 12:11 PM, Andrew Gierth wrote:
>>>>>> "Adrian" == Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>
> >> yeesh. that's a very long-winded way to write current_date + 7
>
> Adrian> Yeah, I was just working of the OP's original DEFAULT:
>
> Adrian> site_mode_date timestamp NOT NULL DEFAULT date_trunc('day',
> Adrian> LOCALTIMESTAMP)+7,
>
> Right, but since all these are exactly equivalent:
>
> CURRENT_DATE
> LOCALTIMESTAMP::date
> date_trunc('day',LOCALTIMESTAMP)::date
>
> and since date can be cast to timestamp, then DEFAULT current_date+7
> would seem to be the simplest answer.
>
I would agree. Put it down to a case of tunnel vision.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chanon Sajjamanochai | 2019-05-01 01:55:50 | PostgreSQL Asian language support for full text search using ICU (and also updating pg_trgm) |
| Previous Message | Andrew Gierth | 2019-04-30 19:11:59 | Re: ERROR: operator does not exist: timestamp without time zone + integer |