Skip to main content

New answers tagged

0 votes

Finding id of last child in table structure

I am not sure if its efficient but this is how I solve such "tree/hierarchy" problem. WITH RECURSIVE message_tree(message_id, message_ids, hierarchy_level) AS ( -- create a tree by using ...
Sahap Asci's user avatar
  • 3,009
12 votes
Accepted

Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?

No, it's not documented and therefore not guaranteed. In practice, it probably is guaranteed as I described in a Stack Overflow answer (reproduced below) but that doesn't meet your stated desire for ...
Paul White's user avatar
  • 87k

Top 50 recent answers are included