Bruno Wolff III <bruno@wolff.to> writes:
> Hadley Willan <hadley.willan@deeperdesign.co.nz> wrote:
>> dateRange = ''now''::date - ( 7 * '1 week'::interval );
> If you actually are using a date you don't have to use an interval as
> the number subtracted will be in days. So you could just use
> current_date - (7 * 7);
Good point --- in fact, that's probably exactly what Hadley wants,
because "date - integer" will yield a date and not a timestamp. The
form involving interval will do odd things when crossing a DST
transition.
regards, tom lane