Postgresql Special Order BY

Question

I need to use an order by on a table but keep some special rows on top. The rows that have name='developer' for example.

Answer 1

ORDER BY CASE WHEN name = 'developer' THEN '0' ELSE name END

Answer 2

Something like this might work for you.

SELECT * FROM table ORDER BY CASE WHEN name = 'developer' THEN 0 ELSE 1 END, name