Re: [HACKERS] Windowing Function Patch Review -> NTILE function

2008-11-10 Thread Hitoshi Harada
2008/11/9 David Rowley <[EMAIL PROTECTED]>: > > I've done a little testing with NTILE(). I think a check should be added to > the ntile() function in wfunc.c. > > david=# select name,salary,ntile(0) over (order by salary) as n from > employees; > ERROR: floating-point exception > DETAIL: An inval

[HACKERS] Windowing Function Patch Review -> NTILE function

2008-11-09 Thread David Rowley
I've done a little testing with NTILE(). I think a check should be added to the ntile() function in wfunc.c. david=# select name,salary,ntile(0) over (order by salary) as n from employees; ERROR: floating-point exception DETAIL: An invalid floating-point operation was signaled. This probably me