Re: order by question.

I'll try this question again.

_____

From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Jose Blanco
Sent: Thursday, May 03, 2007 4:12 PM
To: pgsql-bugs(at)postgresql(dot)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!