On Mon, Apr 19, 2004 at 11:18:23 +1200,
Hadley Willan <hadley.willan@deeperdesign.co.nz> wrote:
> Thanks, that's pretty easy.
>
> I take it I could just use ''now'' instead of a date
>
> 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);
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
