On Sep 18, 3:40 pm, spam_ea...@xxxxxxx (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...@xxxxxxxxxxxxxx) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Yeah, im actually not using 8.4. Any other alternatives? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
