Re: Sorting by constant values

You can order by conditions, lets say column='Unit'. The evaluation of a
conditions will give you 't' or 'f', and alfabetically 'f' < 't'... you
should use DESC to get the matches first. So, it would be more or less like
this:

ORDER BY
column='Unit' DESC,
column='Exterior' DESC,
column='Common' DESC

I don't think this is performant though. If you have many rows to evaluate,
you could create a funtion like this:
CREATE FUNCTION evaluate(TEXT) RETURNS TEXT LANGUAGE 'sql' AS '
SELECT $1='Unit' || $1='Exterior' || $1='Common';
'
This function would return something like 'tff', 'ftf', 'fft', and you
should be able to create an index on that function. Then you can use the
index to order your rows.

Hope it helps ;)

2005/5/3, Robert Fitzpatrick <lists(at)webtent(dot)net>:
>
> 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?
>
> --
> Robert
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>