Home > mailing lists

Ordering by a complex field - Mailing list pgsql-general

From	Robert James
Subject	Ordering by a complex field
Date	July 19, 2007 01:12:50
Msg-id	e09785e00707181812l628f1634j163a4190111dc73a@mail.gmail.com Whole thread Raw
Responses	Re: Ordering by a complex field (Michael Glaesemann <grzm@seespotcode.net>)
List	pgsql-general

Tree view

I have a one varchar field.

I'd like to order so that records where field='2' come first, then '1', then '9', then anything but '0', then '0'. Is there anyway to do this in a standard order by clause (that is, without writing a new SQL function)?

pgsql-general by date:

From: marcelo Cortez
Date: 19 July 2007, 01:00:52
Subject: tsearch2 on postgres8.2.4

From: Michael Glaesemann
Date: 19 July 2007, 01:30:34
Subject: Re: Ordering by a complex field

Ordering by a complex field - Mailing list pgsql-general

Previous

Next