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

From Grzegorz Jaskiewicz
Subject SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?
Date
Msg-id 05A4CFF2-E348-4967-A769-25F8F0AE998E@pointblue.com.pl
Whole thread Raw
Responses Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?
List pgsql-hackers
so I wonder, quite few times ppl asked me about my-word database TOP %  
PERCENT (and I guess ms-word db has it too).
Now that postgres has limit(subselect) - postgresql can do the same  
thing. But, using a count(*) in subselects isn't very efficient. The  
backend gets information from limit X, so I figure it shouldn't be a  
very big deal to add LIMIT %d PERCENT , and pass it on as percentage,  
instead of just number of rows.
I can give it a go and try to implement it myself, but wanted to ask  
here first for opinion on syntax (I have no idea what would be right  
syntax by sql standards), and how keen would you guys be on accepting  
such patch.

thanks.


pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: recursive query crash
Next
From: "Hitoshi Harada"
Date:
Subject: Re: SELECT TOP %d PERCENT, or SELECT ... LIMIT %d PERCENT ?