sort ignoring the, a, ... - Mailing list pgsql-general

From CSN
Subject sort ignoring the, a, ...
Date
Msg-id 20030901203338.53226.qmail@web40604.mail.yahoo.com
Whole thread Raw
Responses Re: sort ignoring the, a, ...
List pgsql-general
Is there a way to sort results as follows?

Acme
The Acme Company
Beer
A Boat Company
Boats
Cars
...

i.e., ignoring leading the's, a's, etc.?

TIA,
CSN


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

pgsql-general by date:

Previous
From: darren@crystalballinc.com
Date:
Subject: Re: Field collection in trigger
Next
From: Peter Eisentraut
Date:
Subject: Re: sort ignoring the, a, ...