Re: order by question. - Mailing list pgsql-bugs

I'll try this question again.



  _____

From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] On Behalf Of Jose Blanco
Sent: Thursday, May 03, 2007 4:12 PM
To: pgsql-bugs@postgresql.org
Subject: [BUGS] order by question.



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!