Re: [sqlalchemy] Postgres not(any_) issue within recursive CTE

On 07/20/2016 07:53 PM, cledo...@twistbioscience.com wrote: Hi, I'm very glad to see the any_ operator fully supported in SqlAlchemy 1.1b2. We'd like to use this operator to implement an efficient recursive CTE (RCTE) that avoids cycles. One way to get an RCTE to avoid cycles is to maintain

[sqlalchemy] Postgres not(any_) issue within recursive CTE

Hi, I'm very glad to see the any_ operator fully supported in SqlAlchemy 1.1b2. We'd like to use this operator to implement an efficient recursive CTE (RCTE) that avoids cycles. One way to get an RCTE to avoid cycles is to maintain an array of visited nodes or links, then to check for