You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was wondering if it is possible to express the following query with Kysely:
WITH RECURSIVE blok_search AS (
-- Base caseSELECT*, 1AS Depth
FROM bloks
WHERE id =1UNION ALL-- Recursive caseSELECT i.*, c.Depth+1FROM bloks i
JOIN blok_search c ONc.Depth<3AND
(
(c.type='headline'AND c."link"=i.id) OR
(c.type='headline'AND c."link2"=i.id) OR
(c.type='child'ANDc.link=i.link)
)
) CYCLE id SET is_cycle USING pathSELECT*FROM blok_search WHERE is_cycle = FALSE;
Hello,
I was wondering if it is possible to express the following query with Kysely:
This is what I got so far: Playground
I tried it with
modifyEnd
but could not place it at the right position:Thank you
The text was updated successfully, but these errors were encountered: