Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ? - Mailing list pgsql-hackers

From Grzegorz Jaskiewicz
Subject Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?
Date
Msg-id 3CF9CDC2-F186-42E6-A24A-A8EAD5668C99@pointblue.com.pl
Whole thread Raw
In response to Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?  ("Hitoshi Harada" <umi.tanuki@gmail.com>)
Responses Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?
List pgsql-hackers
On 2008-10-12, at 16:22, Hitoshi Harada wrote:

> 2008/10/12 Robert Haas <robertmhaas@gmail.com>:
>> I wonder if this could be implemented using the window-function
>> infrastructure...
>>
>
> Yeah, actually window functions I am working now has percent_rank() or
> something he wants. That is better than WITH clauses but still we must
> see the last row before determine the percent. Better than count(*) of
> course, but I'm not sure it meets his needs.
>
excuse my ignorance, apparently I don't recall that patches discussion  
in here. If it pops out, and gets into cvs, can someone remind me of  
that - please ?
Also, will that patch also be able to speed up count(*) , or is it for  
different purpose ? Sorry if I am repeating the subject, if so -  
please just respond in private.

thanks folks.



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Version Number Function?
Next
From: Tom Lane
Date:
Subject: Re: recursive query crash