Re: review: More frame options in window functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: review: More frame options in window functions
Дата
Msg-id 5075.1265993740@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: review: More frame options in window functions  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tom Lane escribi�:
>> Yeah, I don't immediately see anything that would justify going to
>> that level of effort.  Adding +/- as support functions for btree
>> seems like the thing to do.

> Would it work to use a fake access method instead?

Then you'd have to duplicate all the information in a btree opclass;
*and* teach all the stuff that knows about btree to know about fakeam
instead.  Doesn't seem like there's any win there.

> If we add it to
> btree, will we be able to backtrack and move that to a separate catalog
> if we ever determine that it would have been better?

Backwards compatibility with existing user-type definitions is one big
reason to *not* try to pull ORDER BY information out of btree.
        regards, tom lane


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: TCP keepalive support for libpq