Re: review: More frame options in window functions - Mailing list pgsql-hackers

From Hitoshi Harada
Subject Re: review: More frame options in window functions
Date
Msg-id e08cc0401001191202w2e706fe9q8faed1d9b2a8cc13@mail.gmail.com
Whole thread Raw
In response to Re: review: More frame options in window functions  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses 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>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: quoting psql varible as identifier
Next
From: Robert Haas
Date:
Subject: Re: attoptions