On Sat, Sep 19, 2009 at 12:27:10AM -0700, nick wrote: > On Sep 18, 3:40 pm, [email protected] (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 ([email protected]) > > To make changes to your > > subscription:http://www.postgresql.org/mailpref/pgsql-general > > Yeah, im actually not using 8.4. Any other alternatives?
The easiest way would be to upgrade to 8.4 because the workarounds for previous versions are complicated and bug-prone. Cheers, David. -- David Fetter <[email protected]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
