Re: An order by question - Mailing list pgsql-sql

On Sun, Feb 01, 2004 at 06:22:30PM +0100, Tomasz Myrta wrote:
> Dnia 2004-02-01 14:34, U¿ytkownik Michael Fuhr napisa³:
> > SELECT *
> > FROM records
> > ORDER BY lastName,
> >          firstName,
> >          SUBSTRING(term FROM 1 FOR 4),
> >          CASE SUBSTRING(term FROM 5)
> >            WHEN 'S' THEN 1
> >            WHEN 'X' THEN 2
> >            ELSE 3
> >          END;
> 
> or the easier one:
> 
> order by lastname,firstname, translate(term,'SXF','123');

Blast...I just *knew* I was missing an easy, obvious solution.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/