> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Mike Rylander > Sent: Wednesday, January 19, 2005 6:10 PM > To: Rick Schumeyer; PgSql General > Subject: Re: sorting library of congress numbers > > On Wed, 19 Jan 2005 17:37:20 -0500, Rick Schumeyer <rschumeyer@xxxxxxxx> > 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx