2008/11/9 David Rowley <[EMAIL PROTECTED]>: > I'm having a little trouble understanding the standard for NTH_VALUE(). I > would have assumed that NTH_VALUE(name,1) would return the first name in the > window. The current patch is using 0 for the first. >
Hmmm, good point... I haven't thought about it enough, just followed the internal design. The window_seek() in nodeWindow.c, which is an internal API, counts rows from 0 so the external behavior is simlar. Nothing more :-P Giving your comment, actually it seems to me strange that row_number() returns 1 for the first row whereas the ntile(ve, 1) returns the second. If there're no objections I will change it as you told. Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
