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 687c56c80e22f7a236a73e9662f124eb.squirrel@webmail.stinkweasel.net
Whole thread Raw
In response to Re: Plpgsql function to compute "every other Friday"  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
> Not sure if your needs are like mine, but here is the function I use.  It
> stores the date in a config table, and rolls it forward when needed.  It
> also calculates it from some "know payroll date", which I'm guessing was
> near when I wrote it?  (I'm not sure why I choose Nov 16 2008.)  for me,
> this procedure is called a lot, and the things calling it expect it to
> roll into the next pay period.  Not sure if it'll work for you, but might
> offer some ideas.

Great stuff, Andy!  Thank you for this - this function gives me a
lot of great hints about functions in plpgsql.  Very useful
indeed.

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: "C. Bensend"
Date:
Subject: Re: Plpgsql function to compute "every other Friday"