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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
