Your query doesn't appear to include an "order by" clause. The
results won't be sorted without an "order by".
On May 3, 2007, at 4:12 PM, Jose Blanco wrote:
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!
Douglas Toltzman
[EMAIL PROTECTED]
(910) 526-5938
