Re: WIP patch for basic window frame support - Mailing list pgsql-hackers

From Hitoshi Harada
Subject Re: WIP patch for basic window frame support
Date
Msg-id e08cc0400901041652t695cf36coc46c9a3bd4253da6@mail.gmail.com
Whole thread Raw
In response to WIP patch for basic window frame support  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
2009/1/5 Tom Lane <tgl@sss.pgh.pa.us>:
> "Hitoshi Harada" <umi.tanuki@gmail.com> writes:
>> 2008/12/31 Tom Lane <tgl@sss.pgh.pa.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


pgsql-hackers by date:

Previous
From: "Hitoshi Harada"
Date:
Subject: Re: WIP patch for basic window frame support
Next
From: KaiGai Kohei
Date:
Subject: Re: generic reloptions improvement