Select last week

I'm looking at ways to select rows with a timestamp column of "last
week" relative to the current server time.

In 8.3 there's "isoyear" so is this a good approach?

extract( isoyear from foo_time )
= extract( isoyear from now() - interval '1 week' )

AND

extract( week from foo_time )
= extract( week from now() - interval '1 week' )

What about before isoyear was available in Postgresql?

Find the week and then add a week for the range?

date_trunc( 'second', foo_time ) BETWEEN
date_trunc( 'week', now() - interval '1 week' )
AND
date_trunc( 'week', now() - interval '1 week' )
+ interval '1 week' - interval '1 second'

Is there a better approach?

--
Bill Moseley
moseley@hank.org
Sent from my iMutt