Typo in window function docs

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Typo in window function docs

Domingo Alvarez Duarte
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 CURRENT ROW),
        *win2*  AS (PARTITION BY y ORDER BY x)
ORDER BY x;

===

Cheers !

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Typo in window function docs

Dan Kennedy-4
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 t0 --<<<<<
> here the rank function is missing "()"
> WINDOW*win1*  AS (ORDER BY y RANGE BETWEEN UNBOUNDED PRECEDING AND
> CURRENT ROW),
>        *win2*  AS (PARTITION BY y ORDER BY x)
> ORDER BY x;
>
> ===
>
> Cheers !
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users