Re: order by query wrong result

Поиск
Список
Период
Сортировка
От ktm@rice.edu
Тема Re: order by query wrong result
Дата
Msg-id 20141119142700.GI10679@aart.rice.edu
обсуждение исходный текст
Ответ на Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: order by query wrong result  (Scott Ribe <scott_ribe@elevated-dev.com>)
Список pgsql-admin
On Wed, Nov 19, 2014 at 07:13:56AM -0700, Scott Ribe wrote:
> On Nov 19, 2014, at 7:07 AM, jayknowsunix@gmail.com wrote:
> >
> > That doesn't look like an error to me. The upper() function is only converting your name field to upper case and
thenthe "order by" is simply alphabetical based on that, which is what your return values are. 
>
> No, they're not--look again.
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> http://www.elevated-dev.com/
> (303) 722-0567 voice

They are based on your locale.

Regards,
Ken


В списке pgsql-admin по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: order by query wrong result
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: order by query wrong result