X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7ECD5D1D278 for ; Sun, 1 Feb 2004 19:11:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74328-04 for ; Sun, 1 Feb 2004 15:11:16 -0400 (AST) Received: from quality.qadas.com (quality.qadas.com [204.227.16.4]) by svr1.postgresql.org (Postfix) with ESMTP id 453ECD1CCCD for ; Sun, 1 Feb 2004 15:11:15 -0400 (AST) Received: from quality.qadas.com (localhost [127.0.0.1]) by quality.qadas.com (8.12.11/8.12.11) with ESMTP id i11JBCgF006454; Sun, 1 Feb 2004 12:11:12 -0700 (MST) Received: (from mfuhr@localhost) by quality.qadas.com (8.12.11/8.12.11/Submit) id i11JBCvX006453; Sun, 1 Feb 2004 12:11:12 -0700 (MST) Date: Sun, 1 Feb 2004 12:11:12 -0700 From: Michael Fuhr To: Tomasz Myrta Cc: darnold@northcoast.com, pgsql-sql@postgresql.org Subject: Re: An order by question Message-ID: <20040201121112.C18549@quality.qadas.com> References: <20040201133451.GA13002@winnie.fuhr.org> <401D35D6.2020902@klaster.net> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <401D35D6.2020902@klaster.net>; from jasiek@klaster.net on Sun, Feb 01, 2004 at 06:22:30PM +0100 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/8 X-Sequence-Number: 16699 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/