Re: SQL command speed

From: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL command speed
Date: 2000-05-18 20:39:09
Message-ID: 20000518153909.B2549@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hey crew:
I've got a relatively simple SQL problem. In a db backed web site
we're building, I'd like to fill a dropdown box with the contents of a
validation table, in this case research institutions. I want to sort them
alphabetically, but using "library rules": i.e. skip inital articles,
since we've a few 'The University of Foo" and "The Johns Hopkins
University", for example.

I thought I had it with this SQL:

SELECT InstName from Institutions ORDER BY ltrim (InstName, 'The');

Looked good, until I found 'Texas A&M University' sorting below York.

Seems ltrim() removes inital charaters from the set of charaters, not
inital strings, so I was sorting on 'xas A&M University'

Anyone have some magic solution for this?

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kate Collins 2000-05-18 20:46:57 Re: SQL command speed
Previous Message mig 2000-05-18 20:27:42 Re: SQL command speed