Re: [HACKERS] Restriction of windows functions

2016-06-17 Thread Tom Lane
Konstantin Knizhnik writes: > On 17.06.2016 17:01, Tom Lane wrote: >> 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? Because there's no guarantee that that

Re: [HACKERS] Restriction of windows functions

2016-06-17 Thread Konstantin Knizhnik
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

Re: [HACKERS] Restriction of windows functions

2016-06-17 Thread Tom Lane
Konstantin Knizhnik writes: > ERROR: RANGE PRECEDING is only supported with UNBOUNDED > Is there some principle problem in implementing such kind of window? There was such code in the original windowagg patch and it got rejected as being too broken. Please consult the archives. > Certainly it