Re: Pls help - Limiting query results by percentage of results

Josh Berkus  writes:
>> I am trying to limit the results of a query using the LIMIT clause - but 
>> instead of an absolute number I would like to limit by a percentage of rows
>> returned.  

> We don't have that feature, I'm afraid.   You'd have to write a procedure or
> subroutine which calculated that number an then passed it to LIMIT.

This sounds like a proxy for wanting to know the total number of rows
returned by the query, in advance of executing it.  But the backend has
no better idea than you do how many will be returned :-(

			regards, tom lane