Re: Recursive pl/pgsql function ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Recursive pl/pgsql function ...
Date: 2006-10-16 03:27:34
Message-ID: 7543.1160969254@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> More then one Record:
> # select get_next_billing_date(activated, 12) from company_details;
> ERROR: control reached end of function without RETURN
> CONTEXT: PL/pgSQL function "get_next_billing_date"

Hm, what PG version is this? I couldn't duplicate that in HEAD, though
I did find out that a zero or negative payment_period makes it recurse
until "stack depth exceeded".

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-10-16 03:31:04 Re: Assigning a timestamp without timezone to a timestamp
Previous Message Marc G. Fournier 2006-10-16 02:39:51 Recursive pl/pgsql function ...