From: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com> |
Cc: | "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Window Functions: v07 APIs and buffering strateties |
Date: | 2008-10-28 04:20:49 |
Message-ID: | 20081028130511.DC4F.52131E4D@oss.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com> 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.
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 */
> 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.
=# SELECT version();
version
------------------------------------------------------------------------------------------------------
PostgreSQL 8.4devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.5 (mingw-vista special r3)
(1 row)
Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Hitoshi Harada | 2008-10-28 05:05:37 | Re: Window Functions: v07 APIs and buffering strateties |
Previous Message | Hitoshi Harada | 2008-10-28 02:43:51 | Re: Window Functions: v07 APIs and buffering strateties |