Hi Jian, > Hi. > > SELECT v, > lead(v, -2147483648) OVER w AS respect_nulls, > lead(v, -2147483648) IGNORE NULLS OVER w AS ignore_nulls > FROM (VALUES (1), (2)) AS t(v) > WINDOW w AS (ORDER BY v); > > should return all NULL values for column ignore_nulls. > > The fix is to replace the abs function in nodeWindowAgg.c with pg_abs_s32.
Thank you for the report and the fix. Unfortunately I have no time to take care this for now (till November 3rd). I will work on this after November 4th unless someone beats me. Regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp
