Thanks for your testing all! 2008/10/28 ITAGAKI Takahiro <[EMAIL PROTECTED]>: > "Hitoshi Harada" <[EMAIL PROTECTED]> wrote: > >> As I promised, version 7 of the window functions is now released. >> patch: http://umitanuki.net/pgsql/window_functions.patch.20081028.gz > > I tested the patch on mingw (Windows) and > got the following warning and error: > > A. gram.y: conflicts: 3 shift/reduce > B. include/nodes/plannodes.h:650: error: syntax error before "uint" > > I have no idea about A.
I have noticed it but didn't think it is a problem, but it doesn't occur in production, does it? > > B is reported on the type 'uint' in struct Window. > I can compile the code if I replace 'uint' to 'uint32' > > typedef struct Window > { > ... > uint preceding_rows; /* used only when FRAME_ROWS */ > uint following_rows; /* used only when FRAME_ROWS */ I didn't know it. will fix it. > >> SELECT sum(i) OVER (ORDER BY i) FROM generate_series(1, 10) i; > > works fine, but... > >> select relid,AVG(seq_Scan) OVER (ORDER BY relid) >> FROM pg_stat_user_tables >> GROUP BY relid,seq_scan; > > crashes with segfault. I reproduced it on linux of my environment, building without debug/cassert. It could be a problem around there. 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