Re: review: More frame options in window functions
Hitoshi Harada <umi.tanuki@gmail.com>
From: Hitoshi Harada <umi.tanuki@gmail.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-01-16T08:29:49Z
Lists: pgsql-hackers
2010/1/16 Erik Rijkers <er@xs4all.nl>: > >> Thanks for the review. I've found another crash today and attached is >> fixed version. The case is: >> >> SELECT four, sum(ten) over (PARTITION BY four ORDER BY four RANGE 1 >> PRECEDING) FROM tenk1 WHERE unique1 < 10; >> > > Hi, > > The patch (more_frame_options.20100115.patch.gz) applies cleanly, but the regression test gives: It doesn't happen here. Could you send more information like configure options and EXPLAIN output of that query? Regards, -- Hitoshi Harada