Re: Restriction of windows functions - Mailing list pgsql-hackers

From Konstantin Knizhnik
Subject Re: Restriction of windows functions
Date
Msg-id 57640BAD.10400@postgrespro.ru
Whole thread Raw
In response to Re: Restriction of windows functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Restriction of windows functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should phraseto_tsquery('simple', 'blue blue') @@ to_tsvector('simple', 'blue') be true ?
Next
From: Tom Lane
Date:
Subject: Re: New design for FK-based join selectivity estimation