Re: [v9.2] make_greater_string() does not return a string in some cases

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [v9.2] make_greater_string() does not return a string in some cases
Дата
Msg-id
23159.1316709356@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [BUGS] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [BUGS] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
[v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases horiguchi.kyotaro@oss.ntt.co.jp
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Kyotaro HORIGUCHI <horiguchi.kyotaro@oss.ntt.co.jp>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Marcin Mańk <marcin.mank@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Peter Eisentraut <peter_e@gmx.net>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Peter Eisentraut <peter_e@gmx.net>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Greg Stark <stark@mit.edu>
Re: [v9.2] make_greater_string() does not return a string in some cases Robert Haas <robertmhaas@gmail.com>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Re: [v9.2] make_greater_string() does not return a string in some cases Greg Stark <stark@mit.edu>
Re: [v9.2] make_greater_string() does not return a string in some cases Tom Lane <tgl@sss.pgh.pa.us>
Robert Haas  writes:
> On Thu, Sep 22, 2011 at 11:46 AM, Tom Lane  wrote:
>> Well, the metric that we were indirectly using earlier was the
>> number of characters in a given locale for which the algorithm
>> fails to find a greater one (excluding whichever character is "last",
>> I guess, or you could just recognize there's always at least one).

> What about characters that sort differently in sequence than individually?

Yeah, there's a whole 'nother set of issues there, but the character
incrementer is unlikely to affect that very much either way, I think.

> But now that I think about it, what about using some
> slightly-less-stupid version of that approach as a fallback strategy?
> For example, we could pick, oh, say, 20 characters out of the space of
> code points, about evenly distributed under whatever collations we
> think are likely to be in use.

Sure, if the "increment the top byte" strategy proves to not accomplish
that effectively.  But I'd prefer not to design a complex strategy until
it's been proven that a simpler one doesn't work.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Fujii Masao
Дата:
FAQ