Sorting by constant values

From: Robert Fitzpatrick <lists(at)webtent(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Sorting by constant values
Date: 2005-05-03 17:29:03
Message-ID: 1115141343.20235.28.camel@columbus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Bryden 2005-05-03 17:32:20 Date addition/subtraction
Previous Message Alexandre Biancalana 2005-05-03 17:25:50 Re: postgresql 8 abort with signal 10