Documentation Source Text

Check-in [2f154421cf]
Login

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

Overview
Comment:Add documentation for the Tcl command "db function" -returntype option.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 2f154421cf36d22902764ee9df3da35382e7c50c6b981226c6a8e2a26fd9fa58
User & Date: dan 2019-02-27 16:51:20.982
Context
2019-02-28
17:29
Documentation on the bind_falback method of the TCL interface. (check-in: fb20146338 user: drh tags: trunk)
2019-02-27
16:51
Add documentation for the Tcl command "db function" -returntype option. (check-in: 2f154421cf user: dan tags: trunk)
13:46
Updates to the althttpd.md documentation. (check-in: 9ea89e32bf user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/tclsqlite.in.
615
616
617
618
619
620
621















622
623
624
625
626
627
628
<dt><b>-deterministic</b>
<dd><p>
This option indicates that the function will always return the same
answer given the same argument values.  The SQLite query optimizer
uses this information to cache answers from function calls with 
constant inputs and reuse the result rather than invoke the function
repeatedly.















</dl>
</blockquote>
}

##############################################################################
METHOD nullvalue {








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
<dt><b>-deterministic</b>
<dd><p>
This option indicates that the function will always return the same
answer given the same argument values.  The SQLite query optimizer
uses this information to cache answers from function calls with 
constant inputs and reuse the result rather than invoke the function
repeatedly.
</dl>

<dt><b>-returntype integer|real|text|blob|any</b>
<dd><p>
This option is used to configure the type of the result returned by the
function.  If this option is set to "any" (the default), SQLite attempts to
determine the type of each value returned by the function implementation based
on the Tcl value's internal type. Or, if it is set to "text" or "blob", the
returned value is always a text or blob value, respectively. If this option is
set to "integer", SQLite attempts to coerce the value returned by the function
to an integer. If this is not possible without data loss, it attempts to coerce
it to a real value, and finally falls back to text. If this option is set to
"real", an attempt is made to return a real value, falling back to text if this
is not possible.

</dl>
</blockquote>
}

##############################################################################
METHOD nullvalue {