Documentation Source Text

Check-in [ad4301a8a1]
Login

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

Overview
Comment:Add documentation for the sqlite_source_id() SQL function.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ad4301a8a1dbccb7e6fa41402a51f3c730875a8f
User & Date: drh 2009-08-14 18:28:36.000
Context
2009-08-14
18:43
Update the documentation makefile to use mksqlite3h.tcl rather than trying to process sqlite.h.in on its own. (check-in: e982745da1 user: drh tags: trunk)
18:28
Add documentation for the sqlite_source_id() SQL function. (check-in: ad4301a8a1 user: drh tags: trunk)
18:26
Update hyperlinks to point at the fossil-scm rather than CVSTrac. (check-in: 8de414fe8f user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
1674
1675
1676
1677
1678
1679
1680








1681
1682
1683
1684

1685
1686
1687
1688
1689
1690
1691
funcdef {soundex(X)} {} {
  Compute the soundex encoding of the string <i>X</i>.
  The string "?000" is returned if the argument is NULL.
  This function is omitted from SQLite by default.
  It is only available the -DSQLITE_SOUNDEX=1 compiler option
  is used when SQLite is built.
}









funcdef {sqlite_version()} {sqlite_version} {
  Return the version string for the SQLite library
  that is running.  Example:  "3.5.9"

}

funcdef {substr(X,Y,Z) substr(X,Y)} {} {
  Return a substring of input string <i>X</i> that begins
  with the <i>Y</i>-th character and which is <i>Z</i> characters long.
  If <i>Z</i> is omitted then all character through the end of the string
  are returned.







>
>
>
>
>
>
>
>



|
>







1674
1675
1676
1677
1678
1679
1680
1681
1682
1683
1684
1685
1686
1687
1688
1689
1690
1691
1692
1693
1694
1695
1696
1697
1698
1699
1700
funcdef {soundex(X)} {} {
  Compute the soundex encoding of the string <i>X</i>.
  The string "?000" is returned if the argument is NULL.
  This function is omitted from SQLite by default.
  It is only available the -DSQLITE_SOUNDEX=1 compiler option
  is used when SQLite is built.
}

funcdef {sqlite_source_id()} {sqlite_source_id} {
  Return a string that identifies the specific version of the source code
  that was used to build the SQLite library.  The return string begins with
  the date and time that the source code was checked in and is follows by
  an SHA1 hash that uniquely identifies the source tree.  This function is
  an SQL wrapper around the [sqlite3_sourceid()] C interface.
}

funcdef {sqlite_version()} {sqlite_version} {
  Return the version string for the SQLite library
  that is running.  Example:  "3.5.9".  This function is an SQL
  wrapper around the [sqlite3_libversion()] C-interface.
}

funcdef {substr(X,Y,Z) substr(X,Y)} {} {
  Return a substring of input string <i>X</i> that begins
  with the <i>Y</i>-th character and which is <i>Z</i> characters long.
  If <i>Z</i> is omitted then all character through the end of the string
  are returned.