Documentation Source Text

Check-in [61483bc834]

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

Comment:Pre-expand key railroad diagrams in the windowfunctions.html page.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 61483bc834c9ca72dd857fc0334f7565c1c871023b819f25849a06fa804f4aa3
User & Date: drh 2018-08-15 13:21:40
Fix a duplicate fragment name in lang_expr.html check-in: 8ffd68dac7 user: drh tags: trunk
Pre-expand key railroad diagrams in the windowfunctions.html page. check-in: 61483bc834 user: drh tags: trunk
Fixes to the CGI handling in althttpd.c. check-in: 6faf1e47b9 user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

     7      7   
     8      8   <p>A window function is a special SQL function where the input
     9      9   values are taken from
    10     10   a "window" of one or more rows in the results set of a SELECT statement.
    11     11   
    12     12   
    13     13   <tcl>
    14         -RecursiveBubbleDiagram window-function-invocation
           14  +RecursiveBubbleDiagram window-function-invocation window-defn frame-spec filter
    15     15   </tcl>
    16     16   
    17     17   <p>Window functions are distinguished from ordinary SQL functions by the
    18     18   presence of an OVER clause.  If a function invocation has an OVER clause
    19     19   then it is a window function, and if lacks a OVER clause it is an ordinary
    20     20   function.  Window functions might also have a FILTER
    21     21   clause in between the function and the OVER clause.