Re: Return record on recursive call - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: Return record on recursive call
Date
Msg-id 20070528214007.GA65520@winnie.fuhr.org
Whole thread Raw
In response to Return record on recursive call  ("Alexander B." <burbello3000@yahoo.com.br>)
Responses Re: Return record on recursive call  (Adam Radłowski <adamr@informatyka.gdansk.pl>)
List pgsql-admin
On Mon, May 28, 2007 at 05:06:55PM -0300, Alexander B. wrote:
> I am creating a function that when finished the last level, should
> return for each row.
> I put raise notice to trace and the result is correct, but when I try to
> execute, an error is showed.
>
> "ERRO: wrong record type supplied in RETURN NEXT"
>
> I created other functions the same way and worked, basically using the
> same structure but not recursive.
> Is it different return when using recursive.

It's hard to say what's wrong with your sample code without seeing
it with its surrounding context.  Could you post a complete example?
Please reduce the problem to the smallest possible example that
exhibits the undesirable behavior.

This question is a bit off-topic for pgsql-admin; you might get
more help on pgsql-general.

--
Michael Fuhr

pgsql-admin by date:

Previous
From: "Alexander B."
Date:
Subject: Return record on recursive call
Next
From: Adam Radłowski
Date:
Subject: Re: Return record on recursive call