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

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [v9.2] make_greater_string() does not return a string in some cases
Дата
Msg-id 1317034343.1759.13.camel@fsopti579.F-Secure.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
Список pgsql-hackers
On fre, 2011-09-23 at 20:35 +0300, Marcin Mańk wrote:
> One idea:
> col like 'foo%' could be translated to col >= 'foo' and col <= foo || 'zzz' , where 'z' is the largest possible
character.This should be good enough  for calculating stats.
 
> 
>  How to find such a character, i do not know.

That's what makes this so difficult.

If we knew the largest character, we could probably also find the
largest-1, largest-2, etc. characters and determine the total order of
everything.



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

Предыдущее
От: crocket
Дата:
Сообщение: Is there any plan to add unsigned integer types?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Is there any plan to add unsigned integer types?