charlie clark <charlie@xxxxxxxxxxxxxx> writes: > is there a simple way to change the way ORDER BY works on columns with > NULLs? No, but you can do something like ORDER BY foo IS NOT NULL, foo DESC to make the nulls come first. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq