Re: [sqlite] Typo in window function docs

On 07/06/2018 03:59 AM, Charles Leifer wrote: In section 2, the docs read: The default is: RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW I believe it should read instead: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW Thanks. Now fixed here:

[sqlite] Typo in window function docs

In section 2, the docs read: The default is: RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW I believe it should read instead: RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Typo in window function docs

On 07/02/2018 03:14 PM, Domingo Alvarez Duarte wrote: Hello ! This sql example on the new window function docs is missing the parenthesis on the "rank" function: Thanks for pointing this out. New version uploaded now. Dan. === SELECT x, y, row_number() OVER*win1*, rank OVER*win2*

[sqlite] Typo in window function docs

Hello ! This sql example on the new window function docs is missing the parenthesis on the "rank" function: === SELECT x, y, row_number() OVER*win1*, rank OVER*win2* FROM t0 --< here the rank function is missing "()" WINDOW*win1* AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND