Hitoshi Harada Wrote: > As I promised, version 7 of the window functions is now released. At > the same time, git repository branch comes back to master. > > git: http://git.postgresql.org/?p=~davidfetter/window_functions/.git > patch: http://umitanuki.net/pgsql/window_functions.patch.20081028.gz
I've been testing for a couple of hours now and just comparing results to the results Oracle gives me. Perhaps not the best method but it's faster than reading through the spec. I managed to get a seg-fault with the following query. select salary,dense_rank() over (order by salary desc) from employee group by salary; It's the group by that does it. test=# select salary,dense_rank() over (order by salary desc) from employee group by salary; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Failed. It seems to be possible to crash not just dense_rank() and rank(). This crashes too. select relid,AVG(seq_Scan) OVER (ORDER BY relid) FROM pg_stat_user_tables GROUP BY relid,seq_scan; Oracle allows both these queries. Of course I changed table names and column names to make the test case a bit easier to re-produce. Looking forward to seeing windowing functions in 8.4! David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers