Is this "order by" logic right

Поиск
Список
Период
Сортировка
От Josué Maldonado
Тема Is this "order by" logic right
Дата
Msg-id 3F71AD68.8070807@lamundial.hn
обсуждение исходный текст
Ответы Re: Is this "order by" logic right
Re: Is this "order by" logic right
Список pgsql-general
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 по дате отправления: