Finding last day in a month

This is perhaps more of a style question. I'm trying to find the 'right'
way with date/time functions to pull out the last day in a month from a
set of data that might contain rows that don't fall on the actual last
date (e.g. Friday 2004-07-30)

Foo.info_at("2004-07") # contains some logic to make "2004-07-%" for:

WHERE foo_date LIKE ? ORDER BY foo_date DESC LIMIT 1

This feels quite hacky to me for some reason but at least seems to work.

(I'd originally had foo_date = ?::date+'1month'::interval-'1day'::interval !)

Paul

--
Paul Makepeace .............................. http://paulm.com/inchoate/

"What is do I smell? A thousand paths to choose."
-- http://paulm.com/toys/surrealism/