From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com>, "David Rowley" <dgrowley(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | WIP patch for basic window frame support |
Date: | 2008-12-30 20:49:51 |
Message-ID: | 1401.1230670191@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
No docs or regression tests yet, but it seems to work ... please check
against Oracle and DB2 behavior. Supported cases are
RANGE UNBOUNDED PRECEDING -- same as AND CURRENT ROW
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
ROWS UNBOUNDED PRECEDING -- same as AND CURRENT ROW
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
regards, tom lane
Attachment | Content-Type | Size |
---|---|---|
window-frames-1.patch.gz | application/octet-stream | 13.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2008-12-30 21:07:33 | Re: about truncate |
Previous Message | Devrim GÜNDÜZ | 2008-12-30 20:12:41 | New shapshot RPMs (Dec 29, 2008) are ready for testing |