2008/11/12 1:09 Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>:
> So obviously nth_value(expr, 0) causes error and nth_value(expr, 1)
> returns the first row. I will update my patch soon.

Fixed these issues:
- ntile() value check
- nth_value() value check and behavior change

Also, I found a bug that is fixed in this release:

SELECT sum(salary) OVER w1, count(*) OVER w2 FROM empsalary WINDOW w1
AS (ORDER BY salary), w2 AS (ORDER BY salary);

The identical windows named differently were not processed
appropriately. It works now.


Regards,



-- 
Hitoshi Harada

In response to

• Re: Windowing Function Patch Review -> NTH_VALUE at 2008-11-11 16:09:02 from Hitoshi Harada

Responses

• Re: Windowing Function Patch Review -> NTH_VALUE at 2008-11-12 09:47:12 from Hitoshi Harada

pgsql-hackers by date

Next:	From: Hitoshi Harada	Date: 2008-11-12 09:47:12
	Subject: Re: Windowing Function Patch Review -> NTH_VALUE
Previous:	From: Martijn van Oosterhout	Date: 2008-11-12 07:18:57
	Subject: Re: Block-level CRC checks