Postgres Pro
Downloads
Home   >   mailing lists

Sorting by constant values - Mailing list pgsql-general

From Robert Fitzpatrick
Subject Sorting by constant values
Date
Msg-id 1115141343.20235.28.camel@columbus
Whole thread Raw
Responses Re: Sorting by constant values
Re: Sorting by constant values
Re: Sorting by constant values
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alexandre Biancalana
Date:
Subject: Re: postgresql 8 abort with signal 10
Next
From: "Craig Bryden"
Date:
Subject: Date addition/subtraction