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!