Comment on The surprisingly difficult problem of user-defined order in SQLparentComments−RHSeeger5yMy understanding is that it's possible, but not fast. A quick google search turned up this page, but I'm sure there are more https://stackoverflow.com/questions/515749/how-do-i-sort-a-l...I seem to recall seeing _something_ more elegant than a linked list for this type of thing, but I don't recall what is what, offhand.−names_are_hard5yAll the answers on that page, except perhaps the Oracle one which uses a technique in not familiar with, are using recursion in CTEs
Comments
My understanding is that it's possible, but not fast. A quick google search turned up this page, but I'm sure there are more https://stackoverflow.com/questions/515749/how-do-i-sort-a-l...
I seem to recall seeing _something_ more elegant than a linked list for this type of thing, but I don't recall what is what, offhand.
All the answers on that page, except perhaps the Oracle one which uses a technique in not familiar with, are using recursion in CTEs