On Thu, Oct 28, 2004 at 03:36:00PM -0400, Robert Fitzpatrick wrote:
> I would like all those on the same street grouped together. Is there any
> tricks to getting the street names sorted first, possibly where numbers
> and strings separate?
You could do something like
CREATE FUNCTION streetname(text) RETURNS text AS '
SELECT substring($1 FROM ''[a-zA-Z ]+$'')
' LANGUAGE 'SQL';
and then add an ORDER BY streetname(address) to your select.
In response to
pgsql-general by date
|Next:||From: Joshua D. Drake||Date: 2004-10-28 21:55:41|
|Subject: Re: Sorting street addresses|
|Previous:||From: CSN||Date: 2004-10-28 21:08:21|
|Subject: Derived tables?|