Documentation Source Text

Check-in [6307058276]
Login

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

Overview
Comment:Document the -argcount and -deterministic options to the "function" method of the TCL interface.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 6307058276a39f3a7f4c4a6d4204a438bfac3e2d
User & Date: drh 2015-03-13 12:42:36
Context
2015-03-23
13:24
Escape less-than characters in code examples. check-in: b6106e65ef user: drh tags: trunk
2015-03-13
12:42
Document the -argcount and -deterministic options to the "function" method of the TCL interface. check-in: 6307058276 user: drh tags: trunk
2015-03-09
19:43
Merge the tempfiles.html type fix from the 3.8.8 branch. check-in: 685ed5c5f4 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/tclsqlite.in.

578
579
580
581
582
583
584


















585
586
587
588
589
590
591
its numeric argument in to a hexadecimal encoded string:
</p>

<blockquote><b>
db function hex {format 0x%X}
</b></blockquote>



















}

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

<p>
The "nullvalue" method changes the representation for NULL returned







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







578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
its numeric argument in to a hexadecimal encoded string:
</p>

<blockquote><b>
db function hex {format 0x%X}
</b></blockquote>

<p>The "function" method accepts the following options:
<blockquote>
<dl>

<dt><b>-argcount</b> <i>INTEGER</i></dt>
<dd><p>
Specify the number of arguments that the SQL function accepts.  The default
value of -1 means any number of arguments.

<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 {

<p>
The "nullvalue" method changes the representation for NULL returned