Thanks to everybody for your technical tips and help.
Hadley
On Mon, 2004-04-19 at 16:42, Tom Lane wrote:
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
