How to do a special order clause in postgresql?

Question

I have a result set like this: a b c

This result will be fixed each time. What I need to do is order the rows like this a c b. How can I do that ?

Does this answer your question? Postgresql Custom Order for fixed values — bartolo-otrit
– bartolo-otrit, Commented Dec 29, 2020 at 11:37

Quassnoi · Accepted Answer · 2011-07-14 11:49:01Z

4

SELECT  value
FROM    mytable
ORDER BY
        CASE value WHEN 'a' THEN 1 WHEN 'c' THEN 2 WHEN 'b' THEN 3 END

answered Jul 14, 2011 at 11:49

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Or... order by some_immutable_function(value)