Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: sort ignoring the, a, ...
Date
Msg-id Pine.LNX.4.44.0309012322080.1206-100000@peter.localdomain
Whole thread Raw
In response to sort ignoring the, a, ...  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
CSN writes:

> Is there a way to sort results as follows?

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

Not built in.  You'll need to use some kind of pattern matching to strip
off the leading articles.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-general by date:

Previous
From: CSN
Date:
Subject: sort ignoring the, a, ...
Next
From: Peter Eisentraut
Date:
Subject: Re: inserting via "on insert" rule