News for hackers. Stuff that matters.
Re:User-defined Order in SQL by dzamo_norton on Wednesday March 21, 2018 @12:02PM (#16639311)

  with recursive todo_list_sorted as (
  	select
  		*
  	from
  		todo_list tl1 where prev_id is null
  	union all
  	select
  		tl1.*	
  	from
  		todo_list tl1
  	join
  		todo_list_sorted tl2 on tl1.prev_id = tl2.id
  )
  select * from todo_list_sorted
Re:User-defined Order in SQL by grzm on Wednesday March 21, 2018 @12:08PM (#16639396)
Yes, there are ways to do it. The question is how to do so efficiently. Recursive queries don't benefit from indexes as efficiently as, for example, the solution outlined in the submission.