osdir.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

WITH RECURSIVE implementation


I'm curious if anyone has any thoughts on how to go about implementing
recursive queries. Postgres seems to only allow recursive queries with the
form "non-recursive-term UNION [ALL] recursive-term" and uses a separate
"recursive union" operator.

Costing is also certainly a challenge since there's no obvious way to know
how many times the recursive query will need to run. Specific suggestions
would probably be best placed on the corresponding issue. Thanks!

https://issues.apache.org/jira/browse/CALCITE-129

--
Michael Mior
mmior@xxxxxxxxxx