Re: Restriction of windows functions

Поиск
Список
Период
Сортировка
От Konstantin Knizhnik
Тема Re: Restriction of windows functions
Дата
Msg-id 57640BAD.10400@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Restriction of windows functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Restriction of windows functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

On 17.06.2016 17:01, Tom Lane wrote:
>
> Certainly it assumes that window is ordered by key and the key type
> supports subtraction, so "text" can not be used here.
> IIRC, the sticking point was defining a reasonably datatype-independent
> (i.e. extensible) notion of distance.

Why it is not possible just to locate "-" or "+ operator for this type?
I do not see any difference here with locating comparison operator 
needed for sorting.

-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: New design for FK-based join selectivity estimation