Re: ERROR: operator does not exist: timestamp without time zone +integer

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