Re: order by question.

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
doug(at)oakstreetsoftware(dot)com
(910) 526-5938