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.