Re: order by question.

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