Re: [INTERFACES] Bug in sortin routine?

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: [INTERFACES] Bug in sortin routine?
Дата
Msg-id 36E53955.6655F50@alumni.caltech.edu
обсуждение исходный текст
Ответ на Bug in sortin routine?  (Eildert Groeneveld <eg@tzv.fal.de>)
Список pgsql-interfaces
> > [...] It seems that the sorting order on dates is incorrect under
> > certain circumstances: [...]  set DateStyle to 'German'; (does not
> > have an effect on the problem) [...]
> From the examples you gave it appears that you are still using
> American date format (YYYY-MM-DD)

An irrelevant detail: the YYYY-MM-DD date format is ISO-8601, and is not
particularly common in America. The US style looks like MM/DD/YYYY.

I think your analysis and recommendations are correct; the sort order in
the example looked good to me too...

                        - Tom

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [INTERFACES] Getting field length in libpq
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [INTERFACES] Bug in sortin routine?