Sql General
Subject: Re: [GENERAL] sorting library of congress numbers
On Wed, 19 Jan 2005 17:37:20 -0500, Rick Schumeyer
<[EMAIL PROTECTED]>
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 n
+
Subject: Re: [GENERAL] sorting library of congress numbers
To: Rick Schumeyer <[EMAIL PROTECTED]>
On Wed, 19 Jan 2005 18:35:42 -0500, Rick Schumeyer <[EMAIL PROTECTED]> wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:pgsql-general-
> >
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] 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
>
> O
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Scott Marlowe
> Sent: Wednesday, January 19, 2005 5:54 PM
> To: Rick Schumeyer
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] sorting library of congres
On Wed, 19 Jan 2005 17:37:20 -0500, Rick Schumeyer <[EMAIL PROTECTED]> 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 "i0
On Wed, 2005-01-19 at 16:37, Rick Schumeyer 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.
>
>
>
> Currently, the column is a varchar. Unfortunately, a normal string
> comparison
>
> will not work.
>
>
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.
Currently, the column is a varchar. Unfortunately, a
normal string comparison
will not work.
First, has anyone done this already?
If not, I’m thinking I w