Index: www/lang.tcl
==================================================================
--- www/lang.tcl
+++ www/lang.tcl
@@ -1,9 +1,9 @@
#
# Run this Tcl script to generate the sqlite.html file.
#
-set rcsid {$Id: lang.tcl,v 1.60 2003/06/07 08:56:09 jplyon Exp $}
+set rcsid {$Id: lang.tcl,v 1.61 2003/06/08 08:36:34 jplyon Exp $}
puts {
Query Language Understood By SQLite
@@ -902,11 +902,12 @@
coalesce(X,Y,...) |
Return a copy of the first non-NULL argument. If
-all arguments are NULL then NULL is returned. |
+all arguments are NULL then NULL is returned. There must be at least
+2 arguments.
glob(X,Y) |
@@ -916,10 +917,17 @@
interface can
be used to override this function and thereby change the operation
of the GLOB operator.
+
+ifnull(X,Y) |
+Return a copy of the first non-NULL argument. If
+both arguments are NULL then NULL is returned. This behaves the same as
+coalesce() above. |
+
+
last_insert_rowid() |
Return the ROWID of the last row insert from this
connection to the database. This is the same value that would be returned
from the sqlite_last_insert_rowid() API function. |
@@ -967,10 +975,16 @@
by the usual sort order. Note that min() is a simple function when
it has 2 or more arguments but converts to an aggregate function if given
only a single argument.
+
+nullif(X,Y) |
+Return the first argument if the arguments are different,
+otherwise return NULL. |
+
+
random(*) |
Return a random integer between -2147483648 and
+2147483647. |