From: David Arnold <darnold@northcoast.com>
To: pgsql-sql@postgresql.org
Subject: An order by question
Date: Fri, 23 Jan 2004 22:24:37 -0800
Message-ID: <3.0.5.32.20040123222437.009f3b60@mail.northcoast.com> (raw)
All,
I need a little help on a sorting problem. Imagine a table, call it
records, that has fields:
lastName
firstName
term
I want to sort the records by last name, then first name, and finally by
term. This almost does what I want:
select * from records order by lastName, firstName, term;
However, the possible values for term are:
2002F
2003S
2003X
2003F
Where F is for fall, S for spring, and X for summer session. Thus, a
straight alphabetical sort doesn't give me what I want. If the year is the
same, then I want a sort with S, then X, then F for identical year.
Any suggestions?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darnold@northcoast.com
Subject: Re: An order by question
In-Reply-To: <3.0.5.32.20040123222437.009f3b60@mail.northcoast.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox