Re: [sqlite] Typo in window function docs

2018-07-06 Thread Dan Kennedy 

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/463da73728db95b3?sbs=0

Dan.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in window function docs

2018-07-05 Thread Charles Leifer 
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://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Typo in window function docs

2018-07-02 Thread Dan Kennedy 

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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo in window function docs

2018-07-02 Thread 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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users