On Tue, 2005-05-03 at 12:29, Robert Fitzpatrick wrote: > I have a column that I want to sort by certain values. The values are > Unit, Exterior and Common. I want all the records with Unit first, > Common second and Exterior last in the sort order. These are the only 3 > possible values, is there a way to sort manually like that with the > alphanumeric values?
case statement should work. http://www.postgresql.org/docs/8.0/static/functions-conditional.html ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
