order by question. - Mailing list pgsql-bugs

From Jose Blanco
Subject order by question.
Date
Msg-id 20070503201232.E8A0F9FB30C@postgresql.org
Whole thread Raw
Responses Re: order by question.  (Douglas Toltzman <doug@oakstreetsoftware.com>)
Re: order by question.  ("Jose Blanco" <blancoj@umich.edu>)
List pgsql-bugs
I'm using version 7.3 of postgres and when I issue the following command



select author, sort_author from itemsbyauthor where sort_author like 'tan%';



I get the following results:



Author                          sort_author



Tan, Weihong            | tan, weihong

 Tang, S. C.             | tang, s. c.

 Tan, Fang               | tan, fang



Note how the tan's are not grouped together when I think they should be.  Is
this something that is fixed in a more current version of postgres?



Thank you!

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #3260: Subtracting intervals
Next
From: Douglas Toltzman
Date:
Subject: Re: order by question.