Re: Sample of user-define window function and other things
От | Hitoshi Harada |
---|---|
Тема | Re: Sample of user-define window function and other things |
Дата | |
Msg-id | e08cc0400901080530x6c7d582apf1576c1c27ebde59@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Sample of user-define window function and other things (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Sample of user-define window function and other things
|
Список | pgsql-hackers |
2009/1/8 Tom Lane <tgl@sss.pgh.pa.us>: > "Hitoshi Harada" <umi.tanuki@gmail.com> writes: >> - Is WinGetFuncArgInPartition()'s argument mark_pos required? For the >> newbies to window functions, it seems a bit confusing, but >> WinSetMarkPos() looks enough for the purpose AFAIK. > > You mean set_mark? It's just to save an extra calculation of the > absolute location of the fetched row. See leadlag_common for an > example use: we can truncate the tuplestore if the offset is constant. Yeah, I mean set_mark :P) I already checked leadlag_common example but abs_pos can be very simply calculated by WinGetCurrentPosition() - offset. So the simpler API is winner to me rather than saving few cycle cpu cost. Regards, -- Hitoshi Harada
В списке pgsql-hackers по дате отправления: