> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
