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

From Pavel Stehule
Subject Re: review: More frame options in window functions
Date
Msg-id 162867791001200206x487b32d9k8b6428add5160283@mail.gmail.com
Whole thread Raw
In response to Re: review: More frame options in window functions  (Hitoshi Harada <umi.tanuki@gmail.com>)
List pgsql-hackers
2010/1/19 Hitoshi Harada <umi.tanuki@gmail.com>:
> 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.
>

I tested it, and reported problems are fixed

Thank you

Pavel

> Regards,
>
>
> --
> Hitoshi Harada
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: An example of bugs for Hot Standby
Next
From: Boszormenyi Zoltan
Date:
Subject: Re: lock_timeout GUC patch