http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
CREATE OR REPLACE FUNCTION public.next_bill_date(d date, period
interval,
i interval)
RETURNS SETOF date
AS $function$
DECLARE
max_date date;
due_date date;
BEGIN
Hey folks,
I am still slogging away on my pet project, and I'm giving up - I
need help from the experts to try to get this function working like
I want it to.
I have a very basic function, thanks to you guys a few months ago:
CREATE OR REPLACE FUNCTION public.next_bill_date(d date,
On Fri, Jun 10, 2011 at 9:28 PM, C. Bensend be...@bennyvision.com wrote:
SELECT next_bill_date( '2011-01-01', '1 month', '4 months' );
.. I expect the following result set:
next_bill_date
2011-07-01
2011-08-01
2011-09-01
2011-10-01