Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix some errors in the window functions documentation. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
29a58418bc3efb2212ffa1abe8d77c89 |
| User & Date: | dan 2020-11-19 16:35:27 |
Context
|
2020-11-23
| ||
| 14:55 | Allow substring() as an alias for substr(). (check-in: 33b7cf7178 user: drh tags: trunk) | |
|
2020-11-19
| ||
| 16:35 | Fix some errors in the window functions documentation. (check-in: 29a58418bc user: dan tags: trunk) | |
|
2020-11-18
| ||
| 14:36 | Fix a hyperlink in the carray documentation. (check-in: 46262280d2 user: drh tags: trunk) | |
Changes
Changes to pages/windowfunctions.in.
| ︙ | ︙ | |||
878 879 880 881 882 883 884 |
if( pInt ) res = *pInt;
sqlite3_result_int64(ctx, res);
}
/*
** xValue for sumint().
**
| | | 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 |
if( pInt ) res = *pInt;
sqlite3_result_int64(ctx, res);
}
/*
** xValue for sumint().
**
** Return the current value of the aggregate window function.
*/
static void sumintValue(sqlite3_context *ctx){
sqlite3_int64 res = 0;
sqlite3_int64 *pInt;
pInt = (sqlite3_int64*)sqlite3_aggregate_context(ctx, 0);
if( pInt ) res = *pInt;
sqlite3_result_int64(ctx, res);
|
| ︙ | ︙ | |||
952 953 954 955 956 957 958 |
<li> <b>xValue()</b> - invoked to obtain the value for the row with (x='c').
In this case, 16.
<li> <b>xInverse(5)</b> - remove value "5" from the window.
<li> <b>xStep(1)</b> - add value "1" to the window.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d').
<li> <b>xInverse(3)</b> - remove value "3" from the window. The window now
contains values 8 and 1 only.
| | > | 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 |
<li> <b>xValue()</b> - invoked to obtain the value for the row with (x='c').
In this case, 16.
<li> <b>xInverse(5)</b> - remove value "5" from the window.
<li> <b>xStep(1)</b> - add value "1" to the window.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='d').
<li> <b>xInverse(3)</b> - remove value "3" from the window. The window now
contains values 8 and 1 only.
<li> <b>xValue()</b> - invoked to obtain the value for row (x='e'). 9.
<li> <b>xFinal()</b> - invoked to reclaim any allocated resources.
</ol>
<h1>History</h1>
<p>Window function support was first added to SQLite with release
[version 3.25.0] ([dateof:3.25.0]). The SQLite developers used
the <a href=http://www.postgresql.org>PostgreSQL</a> window function
|
| ︙ | ︙ |