All
Accepted answers
ANDERSON FARIAS · Apr 12, 2017 go to post

Hi timothy 

I was looking to do RegEx matching in a query

I wanted to know if there was already a built in function for this.

But thank you very much for your answer : )

ANDERSON FARIAS · Dec 27, 2016 go to post

Hi Kyle. So... I have a hierarchy, a tree. Each node is a row.

To simplify, imagine only 2 fields: NodeId | ParentId 3 | 2 2 | 1 1 | 0

So, each node knows your father. But I need answer things like: All nodes that are descendants from node x

OK, I can make a object script method or I can use severals "self inner Join", but I would like to use a more elegant way

ANDERSON FARIAS · Dec 27, 2016 go to post

Hi Dmitry. Trank you to your answer.

Hmm, ok, dont have WITH, but there any caché's implementation to recursive queries in SQL? My trouble is about hierarchy, I have a table where each record points to parent's id...