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

On 30/04/2019 16:00, Andrew Gierth wrote:
>>>>>> "Adrian" == Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>
> Adrian> Or cast to a date:
>
> Adrian> test=> select date_trunc('day', localtimestamp)::date + 7;
>
> yeesh. that's a very long-winded way to write current_date + 7

Well, current_date is different: current_date returns a date, so you
only have to do:

select current_date + 7;

The original question (if I remember correctly; have zapped it now) was
about adding an integer to a timestamp, hence the need to truncate it to
a date first as in Adrian's example above.

Ray.

--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie