Re: LIMIT BASED ON PERCENT

But there is any way to do it?<br /><br /><div class="gmail_quote">2009/11/18 Guillaume Lelarge <span dir="ltr"><<a
href="mailto:guillaume@lelarge.info">guillaume@lelarge.info</a>></span><br/><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Le mercredi 18
novembre2009 à 20:24:09, Another Trad a écrit :<br /><div class="im">> No, It doesn't.<br /> > In my machine:<br
/>><br /> > First select<br /> > ERROR:  syntax error at end of input<br /> > LINE 1: select * from
rapadura.clientelimit 20%<br /> >                                                 ^<br /> > Second one:<br />
>ERROR:  argument of LIMIT must not contain subqueries<br /> ><br /> > Postgres 8.3<br /> ><br /><br
/></div>Itworks for Lee because obviously he's working on a 8.4 server. You can use<br /> subquery in a LIMIT clause if
youhave an 8.4 PostgreSQL server. For earlier<br /> releases, there's no way to do this in a single query.<br /><font
color="#888888"><br/><br /> --<br /> Guillaume.<br />  <a href="http://www.postgresqlfr.org"
target="_blank">http://www.postgresqlfr.org</a><br/>  <a href="http://dalibo.com"
target="_blank">http://dalibo.com</a><br/></font></blockquote></div><br />