Postgres 按照特定元素排序

1. 第一种写法

SELECT "local_events".* FROM "local_events" WHERE (event_type is not null) ORDER BY event_type='01' DESC, event_type='02' DESC

2. 第二种写法

SELECT "local_events".* FROM "local_events" ORDER BY position(event_type::text in '01,02')

参考

• github