Re: Is this "order by" logic right - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Is this "order by" logic right
Date
Msg-id 3F71B99E.8070902@fireserve.net
Whole thread Raw
In response to Is this "order by" logic right  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
What should we comment on?

翽 wrote:

> Hello list,
>
> The query has the following in the where:
>
> UPPER(cty_Name) LIKE 'NEW%' ORDER BY cty_name
>
> it returns the data in this way:
>
> Newark
> Newark
> New Britain
> Newburgh
> New Cannan
> New Castle
> Newcomerstown
>
> The table has index on cty_name (btree), I'll appreciate any comments
> or suggestions about it.
>
> Thanks
>


pgsql-general by date:

Previous
From: "Daniel E. Fisher"
Date:
Subject: Help again with 7.3
Next
From: Tom Lane
Date:
Subject: Re: pltcl problem