Skip site navigation (1) Skip section navigation (2)

Re: WIP patch for basic window frame support

From: "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David Rowley" <dgrowley(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: WIP patch for basic window frame support
Date: 2009-01-05 00:52:49
Message-ID: e08cc0400901041652t695cf36coc46c9a3bd4253da6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
2009/1/5 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com> writes:
>> 2008/12/31 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>>> RANGE UNBOUNDED PRECEDING       -- same as AND CURRENT ROW
>>> ROWS UNBOUNDED PRECEDING        -- same as AND CURRENT ROW
>
>> Is this true?
>
> 7.11 syntax rule 9 says so.  AFAICS general rule 5b doesn't discuss the
> case where <window frame bound 2> isn't present, and doesn't need to
> because of syntax rule 9.
>

OK, I've just found it and confirmed Oracle does so.



-- 
Hitoshi Harada

In response to

pgsql-hackers by date

Next:From: Stephen R. van den BergDate: 2009-01-05 01:30:38
Subject: QuickLZ compression algorithm (Re: Inclusion in the PostgreSQL backend for toasting rows)
Previous:From: KaiGai KoheiDate: 2009-01-05 00:44:49
Subject: Re: generic reloptions improvement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group