Re: sorting library of congress numbers

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Mike Rylander
> Sent: Wednesday, January 19, 2005 6:10 PM
> To: Rick Schumeyer; PgSql General
> Subject: Re: [GENERAL] sorting library of congress numbers
>
> On Wed, 19 Jan 2005 17:37:20 -0500, Rick Schumeyer <rschumeyer@ieee.org>
> wrote:
> >
> > I have a table where one of the columns is a library of congress number.
> >
> > I would like to be able to ORDER BY this column.
> >
>
> First off, by LOC numbers do you mean Title Control Numbers like
> "o00325992" or "i0824506030" with an optional vendor name in front of
> them?

I mean the library of congress classification numbers.  For example,
the book "PostgreSQL" by Douglas & Douglas has the classification:
    QA76.9.D3 D685 2003