diff options
Diffstat (limited to 'www/lang_expr.html')
| -rw-r--r-- | www/lang_expr.html | 92 |
1 files changed, 46 insertions, 46 deletions
diff --git a/www/lang_expr.html b/www/lang_expr.html index 7edca23..72c9036 100644 --- a/www/lang_expr.html +++ b/www/lang_expr.html @@ -163,8 +163,8 @@ mk.innerHTML = "►"; <h1 id="syntax"><span>1. </span>Syntax</h1> <p><b><a href="syntax/expr.html">expr:</a></b> -<button id='xa5f3b8e5' onclick='hideorshow("xa5f3b8e5","x17177a92")'>hide</button></p> - <div id='x17177a92' class='imgcontainer'> +<button id='x2d1aeee1' onclick='hideorshow("x2d1aeee1","x371e4367")'>hide</button></p> + <div id='x371e4367' class='imgcontainer'> <div style="max-width:963px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 963.96 1068.77"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/> @@ -645,8 +645,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/filter-clause.html">filter-clause:</a></b> -<button id='x98b6880c' onclick='hideorshow("x98b6880c","x6f03314a")'>show</button></p> - <div id='x6f03314a' style='display:none;' class='imgcontainer'> +<button id='xf887a65e' onclick='hideorshow("xf887a65e","x68b3f5e1")'>show</button></p> + <div id='x68b3f5e1' style='display:none;' class='imgcontainer'> <div style="max-width:422px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 422.381 34.56"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -676,8 +676,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/function-arguments.html">function-arguments:</a></b> -<button id='x73977ab6' onclick='hideorshow("x73977ab6","x779ab17e")'>show</button></p> - <div id='x779ab17e' style='display:none;' class='imgcontainer'> +<button id='x590cf543' onclick='hideorshow("x590cf543","x196fe8d1")'>show</button></p> + <div id='x196fe8d1' style='display:none;' class='imgcontainer'> <div style="max-width:456px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 456.566 223.344"> <circle cx="5" cy="56" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,56 20,60 20,52" style="fill:rgb(0,0,0)"/> @@ -739,8 +739,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='x18036a83' onclick='hideorshow("x18036a83","x49cfd0ec")'>show</button></p> - <div id='x49cfd0ec' style='display:none;' class='imgcontainer'> +<button id='x8e5babbb' onclick='hideorshow("x8e5babbb","x2490394f")'>show</button></p> + <div id='x2490394f' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -801,8 +801,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/literal-value.html">literal-value:</a></b> -<button id='x2851e2dc' onclick='hideorshow("x2851e2dc","x8205f18b")'>show</button></p> - <div id='x8205f18b' style='display:none;' class='imgcontainer'> +<button id='x88973893' onclick='hideorshow("x88973893","x929990f8")'>show</button></p> + <div id='x929990f8' style='display:none;' class='imgcontainer'> <div style="max-width:341px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 341.376 336.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,319 39,324 39,315" style="fill:rgb(0,0,0)"/> @@ -872,8 +872,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/over-clause.html">over-clause:</a></b> -<button id='xcd398ae6' onclick='hideorshow("xcd398ae6","x3809982e")'>show</button></p> - <div id='x3809982e' style='display:none;' class='imgcontainer'> +<button id='x5d7f8ba3' onclick='hideorshow("x5d7f8ba3","x614525d7")'>show</button></p> + <div id='x614525d7' style='display:none;' class='imgcontainer'> <div style="max-width:600px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 600.706 418.392"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -964,8 +964,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='x2a6fa908' onclick='hideorshow("x2a6fa908","x2f852834")'>show</button></p> - <div id='x2f852834' style='display:none;' class='imgcontainer'> +<button id='x907d9d78' onclick='hideorshow("x907d9d78","xc3fe29ed")'>show</button></p> + <div id='xc3fe29ed' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -1174,8 +1174,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='x2f3ff9b2' onclick='hideorshow("x2f3ff9b2","xad93baa8")'>show</button></p> - <div id='xad93baa8' style='display:none;' class='imgcontainer'> +<button id='x919bf8a8' onclick='hideorshow("x919bf8a8","xa550a33e")'>show</button></p> + <div id='xa550a33e' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1236,8 +1236,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/raise-function.html">raise-function:</a></b> -<button id='x118d5a2a' onclick='hideorshow("x118d5a2a","xc503a433")'>show</button></p> - <div id='xc503a433' style='display:none;' class='imgcontainer'> +<button id='x797e2103' onclick='hideorshow("x797e2103","x1d1146d0")'>show</button></p> + <div id='x1d1146d0' style='display:none;' class='imgcontainer'> <div style="max-width:627px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 627.302 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1292,8 +1292,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/select-stmt.html">select-stmt:</a></b> -<button id='x5e2a82d5' onclick='hideorshow("x5e2a82d5","x6cc88482")'>show</button></p> - <div id='x6cc88482' style='display:none;' class='imgcontainer'> +<button id='x74b6c8fd' onclick='hideorshow("x74b6c8fd","x3041f80f")'>show</button></p> + <div id='x3041f80f' style='display:none;' class='imgcontainer'> <div style="max-width:669px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 669.677 1162.3"> <path d="M55,845L667,845L667,99L55,99Z" style="fill:none;stroke-width:3.24;stroke:rgb(211,211,211);" /> <circle cx="6" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> @@ -1571,8 +1571,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/common-table-expression.html">common-table-expression:</a></b> -<button id='xa9f9876a' onclick='hideorshow("xa9f9876a","x9712233e")'>show</button></p> - <div id='x9712233e' style='display:none;' class='imgcontainer'> +<button id='x6b224ed3' onclick='hideorshow("x6b224ed3","x6f31c2a7")'>show</button></p> + <div id='x6f31c2a7' style='display:none;' class='imgcontainer'> <div style="max-width:638px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 638.525 167.4"> <circle cx="5" cy="29" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,29 20,33 20,24" style="fill:rgb(0,0,0)"/> @@ -1642,8 +1642,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/compound-operator.html">compound-operator:</a></b> -<button id='xba5a7bde' onclick='hideorshow("xba5a7bde","x96523997")'>show</button></p> - <div id='x96523997' style='display:none;' class='imgcontainer'> +<button id='xbb1c7ffa' onclick='hideorshow("xbb1c7ffa","xc468e953")'>show</button></p> + <div id='xc468e953' style='display:none;' class='imgcontainer'> <div style="max-width:293px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 293.842 147.96"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1684,8 +1684,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/join-clause.html">join-clause:</a></b> -<button id='x04956505' onclick='hideorshow("x04956505","x8a93a5c0")'>show</button></p> - <div id='x8a93a5c0' style='display:none;' class='imgcontainer'> +<button id='xd51385aa' onclick='hideorshow("xd51385aa","x392f7587")'>show</button></p> + <div id='x392f7587' style='display:none;' class='imgcontainer'> <div style="max-width:793px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 793.282 84.24"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1716,8 +1716,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/join-constraint.html">join-constraint:</a></b> -<button id='x8cd227be' onclick='hideorshow("x8cd227be","x83fa8a1d")'>show</button></p> - <div id='x83fa8a1d' style='display:none;' class='imgcontainer'> +<button id='xe17f8c8e' onclick='hideorshow("xe17f8c8e","xb59c5f2e")'>show</button></p> + <div id='xb59c5f2e' style='display:none;' class='imgcontainer'> <div style="max-width:483px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 483.336 126.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,55 39,59 39,50" style="fill:rgb(0,0,0)"/> @@ -1764,8 +1764,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/join-operator.html">join-operator:</a></b> -<button id='x5836fe43' onclick='hideorshow("x5836fe43","xf1c14c8c")'>show</button></p> - <div id='xf1c14c8c' style='display:none;' class='imgcontainer'> +<button id='x70eb58de' onclick='hideorshow("x70eb58de","xd8f024ba")'>show</button></p> + <div id='xd8f024ba' style='display:none;' class='imgcontainer'> <div style="max-width:620px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 620.333 255.312"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,71 39,76 39,67" style="fill:rgb(0,0,0)"/> @@ -1832,8 +1832,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/ordering-term.html">ordering-term:</a></b> -<button id='xea6946a4' onclick='hideorshow("xea6946a4","x752b5b81")'>show</button></p> - <div id='x752b5b81' style='display:none;' class='imgcontainer'> +<button id='x1cdefdce' onclick='hideorshow("x1cdefdce","x68da45be")'>show</button></p> + <div id='x68da45be' style='display:none;' class='imgcontainer'> <div style="max-width:798px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 798.451 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -1893,8 +1893,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/result-column.html">result-column:</a></b> -<button id='x55736445' onclick='hideorshow("x55736445","xdc7efde0")'>show</button></p> - <div id='xdc7efde0' style='display:none;' class='imgcontainer'> +<button id='x935852c6' onclick='hideorshow("x935852c6","x2db3e4e2")'>show</button></p> + <div id='x2db3e4e2' style='display:none;' class='imgcontainer'> <div style="max-width:398px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 398.054 163.08"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/> @@ -1946,8 +1946,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/table-or-subquery.html">table-or-subquery:</a></b> -<button id='x67b88cbf' onclick='hideorshow("x67b88cbf","xff270422")'>show</button></p> - <div id='xff270422' style='display:none;' class='imgcontainer'> +<button id='x521a854b' onclick='hideorshow("x521a854b","x6c1d55d4")'>show</button></p> + <div id='x6c1d55d4' style='display:none;' class='imgcontainer'> <div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704"> <circle cx="5" cy="36" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/> @@ -2091,8 +2091,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/window-defn.html">window-defn:</a></b> -<button id='xfd77c047' onclick='hideorshow("xfd77c047","x027170f1")'>show</button></p> - <div id='x027170f1' style='display:none;' class='imgcontainer'> +<button id='x100903e1' onclick='hideorshow("x100903e1","xf62db97c")'>show</button></p> + <div id='xf62db97c' style='display:none;' class='imgcontainer'> <div style="max-width:479px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 479.765 380.592"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/> @@ -2172,8 +2172,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/frame-spec.html">frame-spec:</a></b> -<button id='xe3cf578d' onclick='hideorshow("xe3cf578d","x785e0cad")'>show</button></p> - <div id='x785e0cad' style='display:none;' class='imgcontainer'> +<button id='xa8fc17a7' onclick='hideorshow("xa8fc17a7","x2e54fb6e")'>show</button></p> + <div id='x2e54fb6e' style='display:none;' class='imgcontainer'> <div style="max-width:1039px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 1039.65 522.72"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,92 39,97 39,88" style="fill:rgb(0,0,0)"/> @@ -2384,8 +2384,8 @@ mk.innerHTML = "►"; </div> </div> <p><b><a href="syntax/type-name.html">type-name:</a></b> -<button id='xcea30177' onclick='hideorshow("xcea30177","x73743335")'>show</button></p> - <div id='x73743335' style='display:none;' class='imgcontainer'> +<button id='xe7806556' onclick='hideorshow("xe7806556","x106281a3")'>show</button></p> + <div id='x106281a3' style='display:none;' class='imgcontainer'> <div style="max-width:661px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 661.008 110.16"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="45,17 33,21 33,12" style="fill:rgb(0,0,0)"/> @@ -2439,8 +2439,8 @@ mk.innerHTML = "►"; </svg> </div> <p><b><a href="syntax/signed-number.html">signed-number:</a></b> -<button id='x32a1800e' onclick='hideorshow("x32a1800e","x542833a7")'>show</button></p> - <div id='x542833a7' style='display:none;' class='imgcontainer'> +<button id='xa92c4660' onclick='hideorshow("xa92c4660","x56ba8989")'>show</button></p> + <div id='x56ba8989' style='display:none;' class='imgcontainer'> <div style="max-width:292px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 292.013 99.576"> <circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> <polygon points="50,44 39,48 39,40" style="fill:rgb(0,0,0)"/> @@ -2587,7 +2587,7 @@ Integer divide yields an integer result, truncated toward zero. <p>The result of any binary operator is either a numeric value or NULL, except for the <font color="#2c2cf0"><big>||</big></font> concatenation operator, and the <font color="#2c2cf0"><big>-></big></font> and <font color="#2c2cf0"><big>->></big></font> extract operators -which evaluate to either NULL or a text value.</p> +which can return values of any type.</p> <p>All operators generally evaluate to NULL when any operand is NULL, with specific exceptions as stated below. This is in accordance with @@ -3538,5 +3538,5 @@ function are different. For example, the <a href="lang_aggfunc.html#max_agg">ma single argument is an aggregate and the <a href="lang_corefunc.html#max_scalar">max()</a> function with two or more arguments is a simple function. Aggregate functions can usually also be used as window functions. -</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/lang_expr.in?m=7ed1af83ff">2024-02-27 20:24:47</a> UTC </small></i></p> +</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/lang_expr.in?m=7e5fe2fc8d">2024-06-02 10:08:16</a> UTC </small></i></p> |