Re: Is this "order by" logic right

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: 翽 <josue(at)lamundial(dot)hn>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is this "order by" logic right
Date: 2003-09-24 15:34:54
Message-ID: 3F71B99E.8070902@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2003-09-24 16:03:16 Re: pltcl problem
Previous Message Tom Lane 2003-09-24 15:31:49 Re: pltcl problem