On 4/30/19 12:11 PM, Andrew Gierth wrote:
>>>>>> "Adrian" == Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com
