This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Actually, that's a feature | |
Don't worry, that value is only wrong half of the time | |
Even though it doesn't work, how does it feel? | |
Everything looks fine my end | |
How is that possible? | |
I broke that deliberately to do some testing | |
I can have a look but there's a lot of if statements in that code! | |
I can't make that a priority right now | |
I can't test everything | |
I couldn't find any examples of how that can be done anywhere else in the project |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH RECURSIVE cte (id, body, op_id, path, comment_id, depth) AS ( | |
SELECT id, | |
body, | |
op_id, | |
array[id] AS path, | |
comment_id, | |
1 AS depth | |
FROM comments | |
WHERE comment_id = 0 AND post_id = $1 | |
UNION ALL |
NewerOlder