Re: Return 30% of results?

On Sep 18, 3:40 pm, spam_ea(dot)(dot)(dot)(at)gmx(dot)net (Thomas Kellerer) wrote:
> Nick wrote on 18.09.2009 23:31:> Is there a way to return a percentage of the rows found? I tried
> > window functions but get an error...
>
> > ERROR:  syntax error at or near "OVER"
>
> > SELECT id, cume_dist FROM (
> >   SELECT id, cume_dist() OVER (ORDER BY id) FROM employees
> > ) s
> > WHERE cume_dist < 0.3
>
> Works for me. Are you sure you are using Postgrs 8.4?
> (Windowing functions are not available in earlier versions)
>
> Regards
> Thomas
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Yeah, im actually not using 8.4. Any other alternatives?