Home > mailing lists

ORDER BY and ignoring the , a , and an - Mailing list pgsql-general

From	Stoppel, Brett W
Subject	ORDER BY and ignoring the , a , and an
Date	March 29, 2001 17:50:04
Msg-id	AA33E10E16DAD411BDFD0008C7CF50E65636E0@hawk.mail.ukans.edu Whole thread Raw
Responses	PLEASE HELP ME!: binary data in text/varchar? (Swaminathan Natarajan <swami@dcs.uky.edu>)
List	pgsql-general

Tree view

Is it possible to have the ORDER BY option ignore the articles "the ", "a ",
and "an " at the beginning of a VARCHAR, CHAR, TEXT, et cetera field? In
other words, I want my results to come back alphabetized, while ignoring the
aforementioned articles.

Brett Stoppel
Assistant Web Administrator
University of Kansas Academic Computing Services
bstoppel@ku.edu - 785.864.0462 - www.ku.edu

pgsql-general by date:

From: Dave Perkins
Date: 29 March 2001, 17:40:55
Subject: Re: missing data

From: Dave Perkins
Date: 29 March 2001, 18:13:38
Subject: Re: missing data

ORDER BY and ignoring the , a , and an - Mailing list pgsql-general

Previous

Next