Your query doesn't appear to include an "order by" clause. The=20=20
results won't be sorted without an "order by".
On May 3, 2007, at 4:12 PM, Jose Blanco wrote:
> I=92m using version 7.3 of postgres and when I issue the following=20=20
> command
>
>
>
> select author, sort_author from itemsbyauthor where sort_author=20=20
> 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=92s are not grouped together when I think they=20=20
> should be. Is this something that is fixed in a more current=20=20
> version of postgres?
>
>
>
> Thank you!
>
>
>
>
Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938