Re: Plpgsql function to compute "every other Friday"

Поиск
Список
Период
Сортировка
От C. Bensend
Тема Re: Plpgsql function to compute "every other Friday"
Дата
Msg-id 39192caa4dd6f1f4d4eeb5a90fbead58.squirrel@webmail.stinkweasel.net
обсуждение исходный текст
Ответ на Re: Plpgsql function to compute "every other Friday"  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: "C. Bensend"
Дата:
Сообщение: Re: Plpgsql function to compute "every other Friday"
Следующее
От: Gordon Shannon
Дата:
Сообщение: could not access status of transaction 1118722281