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-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
