On Jun 27, 2011, at 10:54 AM, Steve Crawford wrote: > That's just how intervals that represent varying periods of time work. You > would need to write your own. But a series of end-of-month dates is pretty > easy: > select generate_series('2011-06-01'::timestamp , '2012-04-01'::timestamp, '1 > month') - '1 day'::interval;
Yeah, but it's trickier if you have a calendaring app and don't know that date a user has chosen for a monthly recurring event. They might have selected June 30, in which case only February would ever need to be different than the default. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers