Michael Nolan <htf...@gmail.com> writes: > You probably need some kind order by case when .... else .... end clause, > where the else clause deals with the non-VIPs, probably negating the need > for a nulls last clause.
The idiomatic way to do this, assuming that you create an "is_vip bool"
field or some other way to identify VIPs accurately, is
ORDER BY is_vip DESC, last_name, first_name
relying on the fact that bool TRUE > bool FALSE.
regards, tom lane
