But there is any way to do it? 2009/11/18 Guillaume Lelarge <guilla...@lelarge.info>
> Le mercredi 18 novembre 2009 à 20:24:09, Another Trad a écrit : > > No, It doesn't. > > In my machine: > > > > First select > > ERROR: syntax error at end of input > > LINE 1: select * from rapadura.cliente limit 20% > > ^ > > Second one: > > ERROR: argument of LIMIT must not contain subqueries > > > > Postgres 8.3 > > > > It works for Lee because obviously he's working on a 8.4 server. You can > use > subquery in a LIMIT clause if you have an 8.4 PostgreSQL server. For > earlier > releases, there's no way to do this in a single query. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com >
