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!