Documentation Source Text

Check-in [87a9b238b7]
Login

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

Overview
Comment:In expressions page, mention effects of arithmetic operators in summary form.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 87a9b238b76c65b70e0da73ddf8f1e2e1b6b2bc34ce75a306f92bb09fca6ac72
User & Date: larrybr 2022-04-18 21:13:30.488
Context
2022-04-27
09:17
Cherry-pick minor documentation fixes from trunk. (check-in: c869cc4a55 user: drh tags: branch-3.38)
2022-04-18
21:57
Also mention integer divide truncation. (check-in: bd1210ef89 user: larrybr tags: trunk)
21:13
In expressions page, mention effects of arithmetic operators in summary form. (check-in: 87a9b238b7 user: larrybr tags: trunk)
2022-04-13
13:11
Update the change log, syntax diagrams, and SELECT documentation to describe RIGHT and FULL JOIN. More work to be done on this. (check-in: 7dc766ebe1 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang_expr.in.
︙︙
107
108
109
110
111
112
113
114


115
116
117




118
119
120
121
122
123
124

^The non-equals operator can be either
[Operator !=] or [Operator {<>}].
^The [Operator ||] operator is \"concatenate\" - it joins together
the two strings of its operands.
^The [Operator {->}] and [Operator {->>}] operators are \"extract\";
they extract the RHS component from the LHS.
For an example, see
 <a href=\"json1.html#jptr\">JSON subcomponent extraction</a>.


^The [Operator %] operator \[cast|casts\] both of its operands to type
INTEGER and then computes the remainder after dividing the left integer
by the right integer.</p>





<p>^The result of any binary operator is either a numeric value or 
NULL, except for the [Operator ||] concatenation operator,
and the [Operator {-&gt;}] and [Operator {-&gt;&gt;}] extract operators
which evaluate to either NULL or a text value.</p>

<p>All operators generally evaluate to NULL when any operand is NULL,








|
>
>


|
>
>
>
>








107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130

^The non-equals operator can be either
[Operator !=] or [Operator {&lt;&gt;}].
^The [Operator ||] operator is \"concatenate\" - it joins together
the two strings of its operands.
^The [Operator {-&gt;}] and [Operator {-&gt;&gt;}] operators are \"extract\";
they extract the RHS component from the LHS.
For an example, see
 <a href=\"json1.html#jptr\">JSON subcomponent extraction</a>.</p>

<p>
^The [Operator %] operator \[cast|casts\] both of its operands to type
INTEGER and then computes the remainder after dividing the left integer
by the right integer. The other arithmetic operators perform integer
arithmetic if both operands are integers and no overflow would result,
or floating point arithmetic, per IEEE Standard 754, if either operand
is a real value or integer arithmetic would produce an overflow.
</p>

<p>^The result of any binary operator is either a numeric value or 
NULL, except for the [Operator ||] concatenation operator,
and the [Operator {-&gt;}] and [Operator {-&gt;&gt;}] extract operators
which evaluate to either NULL or a text value.</p>

<p>All operators generally evaluate to NULL when any operand is NULL,
︙︙