Re: LIMIT BASED ON PERCENT

But there is any way to do it?

2009/11/18 Guillaume Lelarge <guillaume(at)lelarge(dot)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
>