Re: Plpgsql function to compute "every other Friday" - Mailing list pgsql-general

From C. Bensend
Subject Re: Plpgsql function to compute "every other Friday"
Date
Msg-id 39192caa4dd6f1f4d4eeb5a90fbead58.squirrel@webmail.stinkweasel.net
Whole thread Raw
In response to Re: Plpgsql function to compute "every other Friday"  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
> 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



pgsql-general by date:

Previous
From: "C. Bensend"
Date:
Subject: Re: Plpgsql function to compute "every other Friday"
Next
From: Gordon Shannon
Date:
Subject: could not access status of transaction 1118722281