Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in datatype3.html. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
ea9656e7d7f3492fae95cff6c2ce4f23 |
| User & Date: | drh 2020-02-22 21:35:30.429 |
Context
|
2020-02-25
| ||
| 20:57 | Initial documentation explaining the NUL characters can appear in the middle of TEXT strings and what to do about it. (check-in: e2299b8b80 user: drh tags: trunk) | |
|
2020-02-22
| ||
| 21:35 | Fix a typo in datatype3.html. (check-in: ea9656e7d7 user: drh tags: trunk) | |
| 12:53 | Fix a typo in the when-to-use page. (check-in: 556d3bb6c4 user: drh tags: trunk) | |
Changes
Changes to pages/datatype3.in.
| ︙ | ︙ | |||
282 283 284 285 286 287 288 |
affinity, not REAL affinity, due to the "INT" at the end of "POINT".
^And the declared type of "STRING" has an affinity of NUMERIC, not TEXT.
<tcl>hd_fragment expraff {expression affinity} {Affinity Of Expressions}</tcl>
<h2>Affinity Of Expressions</h2>
<p>Every table column has a type affinity (one of BLOB, TEXT, INTEGER,
| | | 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 |
affinity, not REAL affinity, due to the "INT" at the end of "POINT".
^And the declared type of "STRING" has an affinity of NUMERIC, not TEXT.
<tcl>hd_fragment expraff {expression affinity} {Affinity Of Expressions}</tcl>
<h2>Affinity Of Expressions</h2>
<p>Every table column has a type affinity (one of BLOB, TEXT, INTEGER,
REAL, or NUMERIC) but expressions do not necessarily have an affinity.
<p>Expression affinity is determined by the following rules:
<ul>
<li><p>^The right-hand operand of an IN or NOT IN
operator has no affinity if the operand is a list and has the same
affinity as the affinity of the result set expression if the operand
|
| ︙ | ︙ |