Michael Nolan <htfoot@xxxxxxxxx> 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
