Re:User-defined Order in SQL
by cthor on Wednesday March 21, 2018 @06:06AM
(#16636729)
Ah, ok, I misread. Yeah, that requires a subquery then, but not because of floats being unsuitabe for sorting, but because you're doing a 1-to-many thingy in a 1-to-1 way by hardcoding 3 columns. It's like writing
In code to simplify it, instead of
The former mostly works, but it's definitely not elegant. And you have to be sure the number of items being 3 is set in stone.
[ Parent
| on HN ]
There are no comments on this comment yet.