Postgres Pro
Downloads
Home   >   mailing lists

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

From Josué Maldonado
Subject Is this "order by" logic right
Date
Msg-id 3F71AD68.8070807@lamundial.hn
Whole thread Raw
Responses Re: Is this "order by" logic right  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Is this "order by" logic right  (Dennis Gearon <gearond@fireserve.net>)
List pgsql-general
Tree view 
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

--
Josué Maldonado.

pgsql-general by date:

Previous
From: Russ Brown
Date:
Subject: pltcl problem
Next
From: maufaini@tiscali.it (Maurizio Faini)
Date:
Subject: Re: GET LAST ID INSERT