Re: Sample of user-define window function and other things

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Sample of user-define window function and other things
Дата
Msg-id 13089.1231420301@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Sample of user-define window function and other things  ("Hitoshi Harada" <umi.tanuki@gmail.com>)
Ответы Re: Sample of user-define window function and other things  ("Hitoshi Harada" <umi.tanuki@gmail.com>)
Список pgsql-hackers
"Hitoshi Harada" <umi.tanuki@gmail.com> writes:
> - CREATE FUNCTION command accepts WINDOW keyword for non-c language
> like plpgsql. Don't we need to throw error?

No.  CREATE FUNCTION has no business trying to keep track of which
PLs implement what.  That case won't do anything useful right now,
but it might do something useful sometime before 8.4 is dead ...

> - 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.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New patch for Column-level privileges
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: about truncate