> generate_series(date '2001-01-05', date '2020-12-31', interval '2 weeks') > > > will return every payday from jan 5 2001 to the end of 2020 (assuming > the 5th was payday, change the start to jan 12 if that was instead).
And THERE is the winner. I feel like an idiot for not even considering generate_series(). Thanks a bunch, John! This will do nicely! Benny -- "Hairy ape nads." -- Colleen, playing Neverwinter Nights -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
