Re: BUG #8569: with recursive work incorrectly with function

fanjing09 wrote
> The following bug has been logged on the website:
>
> Bug reference: 8569
> Logged by: Jing Fan
> Email address:

> fanjing09@

> PostgreSQL version: 9.1.9
> Operating system: ubuntu 13.04
> Description:
>
> with recursive table as(
> seed statement
> union all
> recursive statement
> )
> in the recursive statement, I use functions, that is select * from
> functionname(). I tried the function seperately and it can return correct
> result. However, the query just stopped recursion when new tuples are
> still
> generated from recursive statement.(actually the recursive part is just
> executed once). I wonder whether it is a bug?

We need to see the actual query you are running AND the "CREATE FUNCTION"
statement that you are using in the recursive part of the query.

It is likely not a bug but rather some combination of function volatility
and/or an incorrect query that is causing the problem.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-8569-with-recursive-work-incorrectly-with-function-tp5776396p5776409.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.