2023-02-06 (first published: 2023-01-23)
654 reads
2023-02-06 (first published: 2023-01-23)
654 reads
2022-04-18
641 reads
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-25 (first published: 2019-11-24)
550 reads
This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node. The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression.
2019-11-12 (first published: 2019-11-08)
1,710 reads
By Steve Jones
I get asked questions by salespeople all the time. Usually this is because a...
By Steve Jones
jouska – a hypothetical conversation that you compulsively play out in your head –...
The invitation this month for #PGSqlPhriday comes from Dian Fay. The topic is pretty...
I've noticed in one of our applications a cursor uses operation 40 and that...
Ok, need someone to talk me off the cursor ledge on this one. I...
Comments posted to this topic are about the item Better Communication Through Less Messaging