Re: poc - possibility to write window function in PL languages

st 20. 1. 2021 v 21:14 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
napsal:

>
>
> st 20. 1. 2021 v 21:07 odesílatel Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napsal:
>
>> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
>> > The second question is work with partition context value. This should be
>> > only one value, and of only one but of any type per function. In this
>> case
>> > we cannot use GET statements. I had an idea of enhancing declaration.
>> Some
>> > like
>>
>> > DECLARE
>> > pcx PARTITION CONTEXT (int); -- read partition context
>> > BEGIN
>> > pcx := 10; -- set partition context
>>
>> > What do you think about it?
>>
>> Uh, what? I don't understand what this "partition context" is.
>>
>
> It was my name for an access to window partition local memory -
> WinGetPartitionLocalMemory
>
> We need some interface for this cache
>

I have to think more about declarative syntax. When I try to transform our
WindowObject API directly, then it looks like Cobol. It needs a different
concept to be user friendly.

Regards

Pavel

> Regards
>
> Pavel
>
>
>
>
>
>
>
>>
>> regards, tom lane
>>
>