Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation on the changes() and total_changes() SQL functions. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
71bdfb826a8703e070f60dbab1f957c4 |
| User & Date: | drh 2009-04-02 02:23:59 |
Context
|
2009-04-02
| ||
| 20:17 | Improvements and clarifications to the auto_vacuum pragma documentation. (check-in: ae7cc4efbb user: drh tags: trunk) | |
| 02:23 | Add documentation on the changes() and total_changes() SQL functions. (check-in: 71bdfb826a user: drh tags: trunk) | |
|
2009-03-31
| ||
| 15:13 | Update the coverage statistics on the testing document. (check-in: 1801a39523 user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
....
1572
1573
1574
1575
1576
1577
1578
1579
1580
1581
1582
1583
1584
1585
|
<table border=0 cellpadding=10>
<tcl>
funcdef {abs(X)} {} {
Return the absolute value of the numeric
argument <i>X</i>. Return NULL if <i>X</i> is NULL. Return 0.0 if
<i>X</i> is not a numeric value.
}
funcdef {coalesce(X,Y,...)} {} {
Return a copy of the first non-NULL argument. If
all arguments are NULL then NULL is returned. There must be at least
2 arguments.
}
................................................................................
are returned.
The left-most character of <i>X</i> is number 1. If <i>Y</i> is negative
the the first character of the substring is found by counting from the
right rather than the left. If <i>X</i> is string
then characters indices refer to actual UTF-8 characters. If
<i>X</i> is a BLOB then the indices refer to bytes.
}
funcdef {trim(X) trim(X,Y)} {} {
Return a string formed by removing any and all
characters that appear in <i>Y</i> from both ends of <i>X</i>.
If the <i>Y</i> argument is omitted, spaces are removed.
}
|
>
>
>
>
>
>
>
>
>
>
>
>
>
|
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
....
1578
1579
1580
1581
1582
1583
1584
1585
1586
1587
1588
1589
1590
1591
1592
1593
1594
1595
1596
1597
1598
|
<table border=0 cellpadding=10>
<tcl>
funcdef {abs(X)} {} {
Return the absolute value of the numeric
argument <i>X</i>. Return NULL if <i>X</i> is NULL. Return 0.0 if
<i>X</i> is not a numeric value.
}
funcdef {changes()} {} {
Return the number of database rows that were changed or inserted or
deleted by the most recently complete SQL. This is a wrapper around
the [sqlite3_changes()] C/C++ function.
}
funcdef {coalesce(X,Y,...)} {} {
Return a copy of the first non-NULL argument. If
all arguments are NULL then NULL is returned. There must be at least
2 arguments.
}
................................................................................
are returned.
The left-most character of <i>X</i> is number 1. If <i>Y</i> is negative
the the first character of the substring is found by counting from the
right rather than the left. If <i>X</i> is string
then characters indices refer to actual UTF-8 characters. If
<i>X</i> is a BLOB then the indices refer to bytes.
}
funcdef {total_changes()} {} {
Return the number of row changes caused by INSERT, UPDATE or DELETE
statements since the current database connection was opened.
This function is a wrapper around the [sqlite3_total_changes()]
C/C++ interface.
}
funcdef {trim(X) trim(X,Y)} {} {
Return a string formed by removing any and all
characters that appear in <i>Y</i> from both ends of <i>X</i>.
If the <i>Y</i> argument is omitted, spaces are removed.
}
|