Documentation Source Text

Check-in [887762cf99]
Login

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

Overview
Comment:Mention that UPSERT does not work for virtual tables.
Timelines: family | ancestors | branch-3.24
Files: files | file ages | folders
SHA3-256:887762cf9916c2e9ec9165f3313a071bb8957ad2be7f900d65f77c8480e4ae6c
User & Date: drh 2018-06-26 18:24:24
Context
2018-06-26
18:24
Mention that UPSERT does not work for virtual tables. Leaf check-in: 887762cf99 user: drh tags: branch-3.24
2018-06-15
19:12
Fix missing "const" in the documentation of the argv parameters to the xCreate and xConnect methods in the sqlite3_module object. check-in: 2ee890a53a user: drh tags: branch-3.24
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/lang.in.

3442
3443
3444
3445
3446
3447
3448




3449
3450
3451
3452
3453
3454
3455

<p>In this last example, the phonebook2 entry is only
updated if the validDate for the newly inserted value is
newer than the entry already in the table.  If the table already
contains an entry with the same name and a current validDate,
then the WHERE clause causes the DO UPDATE to become a no-op.






<tcl>
##############################################################################
Section {ON CONFLICT clause} conflict {{conflict clause} {ON CONFLICT}}

RecursiveBubbleDiagram conflict-clause
</tcl>







>
>
>
>







3442
3443
3444
3445
3446
3447
3448
3449
3450
3451
3452
3453
3454
3455
3456
3457
3458
3459

<p>In this last example, the phonebook2 entry is only
updated if the validDate for the newly inserted value is
newer than the entry already in the table.  If the table already
contains an entry with the same name and a current validDate,
then the WHERE clause causes the DO UPDATE to become a no-op.

<h3>Limitations</h3>

<p>UPSERT does not currently work for [virtual tables].


<tcl>
##############################################################################
Section {ON CONFLICT clause} conflict {{conflict clause} {ON CONFLICT}}

RecursiveBubbleDiagram conflict-clause
</tcl>