Postgres Pro
Downloads
Home   >   mailing lists

Re: Recursive pl/pgsql function ... - Mailing list pgsql-sql

From Tom Lane
Subject Re: Recursive pl/pgsql function ...
Date
Msg-id 7543.1160969254@sss.pgh.pa.us
Whole thread Raw
In response to Recursive pl/pgsql function ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: Recursive pl/pgsql function ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
Re: Recursive pl/pgsql function ...  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-sql
Tree view 
"Marc G. Fournier" <scrappy@postgresql.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

pgsql-sql by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Recursive pl/pgsql function ...
Next
From: Tom Lane
Date:
Subject: Re: Assigning a timestamp without timezone to a timestamp