Re: review: More frame options in window functions

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема Re: review: More frame options in window functions
Дата
Msg-id e08cc0401001191202w2e706fe9q8faed1d9b2a8cc13@mail.gmail.com
обсуждение исходный текст
Ответ на Re: review: More frame options in window functions  (Hitoshi Harada <umi.tanuki@gmail.com>)
Ответы Re: review: More frame options in window functions  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: review: More frame options in window functions  (Robert Haas <robertmhaas@gmail.com>)
Re: review: More frame options in window functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
2010/1/19 Hitoshi Harada <umi.tanuki@gmail.com>:
> Yeah, that's my point, too. The planner has to distinguish "four" from
> sort pathkeys and to teach the executor the simple information which
> column should be used to determine frame. I was bit wrong because some
> of current executor code isn't like it, like using ordNumCols == 0 to
> know whether partition equals to frame, though....

And here's another version to fix this problem (I hope). Now the
planner distinguish sort column from actual significant pathkeys. I
tested it on both of 32bit and 64bit Linux.

Regards,


--
Hitoshi Harada

Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: quoting psql varible as identifier
Следующее
От: Robert Haas
Дата:
Сообщение: Re: attoptions