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:
http://localhost:8080/ci/463da73728db95
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
http:
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* FROM
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 CU
4 matches
Mail list logo