[BUGS] order by question.

[Jose Blanco]

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!