News for hackers. Stuff that matters.

A comment on The surprisingly difficult problem of user-defined order in SQL. Parent comment

Re:The surprisingly difficult problem of user-defined order ... by RHSeeger on Saturday January 16, 2021 @12:38AM (#25800347)
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.

[ Parent | on HN ]
Re:The surprisingly difficult problem of user-defined order ... by names_are_hard on Saturday January 16, 2021 @01:19AM (#25800498)
All the answers on that page, except perhaps the Oracle one which uses a technique in not familiar with, are using recursion in CTEs
[ Parent | on HN ]