Documentation Source Text

Check-in [1c7ab913f0]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Improved linkage to window functions.
Timelines: family | ancestors | descendants | both | branch-3.25
Files: files | file ages | folders
SHA3-256: 1c7ab913f0bfadf4a739a7fe4b7a741c14310d6fd7dbfd04fde9126be4240dc3
User & Date: drh 2018-09-24 14:38:10
Context
2018-09-24
14:46
Clarify the operation of the "weekday" date and time modifier. check-in: b4b8f35ef1 user: drh tags: branch-3.25
14:38
Improved linkage to window functions. check-in: 1c7ab913f0 user: drh tags: branch-3.25
2018-09-21
10:16
Fix a harmless typo in the json documentation. check-in: 2bdb2d7e21 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to common_links.tcl.

     8      8   <li> <a href="chronology.html">Prior Releases</a>
     9      9   <li> <a href="lang.html">SQL Syntax</a>
    10     10   <ul>
    11     11   <li> <a href="pragma.html#toc">Pragmas</a>
    12     12   <li> <a href="lang_corefunc.html">SQL functions</a>
    13     13   <li> <a href="lang_datefunc.html">Date &amp; time functions</a>
    14     14   <li> <a href="lang_aggfunc.html">Aggregate functions</a>
           15  +<li> <a href="windowfunctions.html#biwinfunc">Window functions</a>
    15     16   <li> <a href="json1.html">JSON functions</a>
    16     17   </ul>
    17     18   </li>
    18     19   <li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
    19     20   <ul>
    20     21   <li> <a href="cintro.html">Introduction</a>
    21     22   <li> <a href="c3ref/funclist.html">List of C-language APIs</a>

Changes to pages/lang.in.

  2386   2386   <p>The boolean identifiers TRUE and FALSE are usually just aliases for
  2387   2387   the integer values 1 and 0, respectively.  However, if TRUE or FALSE
  2388   2388   occur on the right-hand side of an IS operator, then they form new
  2389   2389   unary postfix operators "IS TRUE" and "IS FALSE" which test the boolean
  2390   2390   value of the operand on the left.
  2391   2391   
  2392   2392   <h3>Functions</h3>
  2393         -<p>SQLite supports many [corefunc|simple] and [aggfunc|aggregate]
         2393  +<p>SQLite supports many [corefunc|simple], [aggfunc|aggregate],
         2394  +and [window functions|window]
  2394   2395   SQL functions.  For presentation purposes, simple functions are further
  2395         -subdivided into [corefunc | core functions] and [datefunc|date-time functions].
         2396  +subdivided into [corefunc | core functions], [datefunc|date-time functions],
         2397  +and [json1|JSON functions].
  2396   2398   Applications can add new functions, written in C/C++, using the
  2397   2399   [sqlite3_create_function()] interface.
  2398   2400   </p>
  2399   2401   
  2400   2402   <p>^It is possible to have an aggregate function with the same name as a
  2401   2403   simple function, as long as the number of arguments for the two forms of the
  2402   2404   function are different.  ^For example, the [agg_max|max()] function with a
................................................................................
  2785   2787     ^This SQL function is implemented using the [sqlite3_result_zeroblob()]
  2786   2788     routine from the C/C++ interface.
  2787   2789   }
  2788   2790   </tcl>
  2789   2791   
  2790   2792   <p>The core functions shown below are available by default. 
  2791   2793   [datefunc | Date &amp; Time functions],
  2792         -[aggfunc | aggregate functions], and
         2794  +[aggfunc | aggregate functions],
         2795  +[builtin window functions|window functions], and
  2793   2796   [json1 | JSON functions] are documented separately.  An
  2794   2797   application may define additional
  2795   2798   functions written in C and added to the database engine using
  2796   2799   the [sqlite3_create_function()] API.</p>
  2797   2800   
  2798   2801   <tcl>
  2799   2802   set lx {}

Changes to pages/windowfunctions.in.

   313    313   for all ORDER BY expressions are considered peers regardless of the frame type.
   314    314   
   315    315   <p> Most built-in window functions ignore the
   316    316   <yynonterm>frame-spec</yynonterm>, the exceptions being first_value(),
   317    317   last_value() and nth_value(). It is a syntax error to specify a FILTER 
   318    318   clause as part of a built-in window function invocation.
   319    319   
          320  +<tcl>hd_fragment biwinfunc {builtin window functions}</tcl>
   320    321   <p> SQLite supports the following 11 built-in window functions:
   321    322   
   322    323   <dl>
   323    324     <dt><p><b>row_number()</b>
   324    325     <dd><p> The number of the row within the current partition. Rows are
   325    326          numbered starting from 1 in the order defined by the ORDER BY clause in
   326    327          the window definition, or in arbitrary order otherwise.