Re: Return 30% of results?
| От | nick |
|---|---|
| Тема | Re: Return 30% of results? |
| Дата | |
| Msg-id | 8e09b25e-4364-4cef-8a81-f0bc13864f0d@e4g2000prn.googlegroups.com обсуждение исходный текст |
| Ответ на | Return 30% of results? (Nick <nboutelier@gmail.com>) |
| Ответы |
Re: Return 30% of results?
Re: Return 30% of results? |
| Список | pgsql-general |
On Sep 18, 3:40 pm, spam_ea...@gmx.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...@postgresql.org) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general Yeah, im actually not using 8.4. Any other alternatives?
В списке pgsql-general по дате отправления: