/ Check-in [190252fe]
Login

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

Overview
Comment:Documented SQL fns IFNULL() and NULLIF(). (CVS 1015)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 190252fee0a86eb6f8c24a2402e36482e3bd514c
User & Date: jplyon 2003-06-08 08:36:34
Context
2003-06-09
11:53
Remove redundant "return" statement from btree_rb.c. (CVS 1016) check-in: 373d0771 user: drh tags: trunk
2003-06-08
08:36
Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) check-in: 190252fe user: jplyon tags: trunk
2003-06-07
11:33
Use sqliteOsFileExists() in the debugging hook in vdbe.c, instead of access(). Ticket #341. (CVS 1014) check-in: 7d3405b9 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/lang.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the sqlite.html file.
     3      3   #
     4         -set rcsid {$Id: lang.tcl,v 1.60 2003/06/07 08:56:09 jplyon Exp $}
            4  +set rcsid {$Id: lang.tcl,v 1.61 2003/06/08 08:36:34 jplyon Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head>
     8      8     <title>Query Language Understood By SQLite</title>
     9      9   </head>
    10     10   <body bgcolor=white>
    11     11   <h1 align=center>
................................................................................
   900    900   <td valign="top" align="right" width=120>abs(<i>X</i>)</td>
   901    901   <td valign="top">Return the absolute value of argument <i>X</i>.</td>
   902    902   </tr>
   903    903   
   904    904   <tr>
   905    905   <td valign="top" align="right">coalesce(<i>X</i>,<i>Y</i>,...)</td>
   906    906   <td valign="top">Return a copy of the first non-NULL argument.  If
   907         -all arguments are NULL then NULL is returned.</td>
          907  +all arguments are NULL then NULL is returned.  There must be at least 
          908  +2 arguments.</td>
   908    909   </tr>
   909    910   
   910    911   <tr>
   911    912   <a name="globFunc"></a>
   912    913   <td valign="top" align="right">glob(<i>X</i>,<i>Y</i>)</td>
   913    914   <td valign="top">This function is used to implement the
   914    915   "<b>Y GLOB X</b>" syntax of SQLite.  The
   915    916   <a href="c_interface.html#cfunc">sqlite_create_function()</a> 
   916    917   interface can
   917    918   be used to override this function and thereby change the operation
   918    919   of the <a href="#glob">GLOB</a> operator.</td>
   919    920   </tr>
   920    921   
          922  +<tr>
          923  +<td valign="top" align="right">ifnull(<i>X</i>,<i>Y</i>)</td>
          924  +<td valign="top">Return a copy of the first non-NULL argument.  If
          925  +both arguments are NULL then NULL is returned. This behaves the same as 
          926  +<b>coalesce()</b> above.</td>
          927  +</tr>
          928  +
   921    929   <tr>
   922    930   <td valign="top" align="right">last_insert_rowid()</td>
   923    931   <td valign="top">Return the ROWID of the last row insert from this
   924    932   connection to the database.  This is the same value that would be returned
   925    933   from the <b>sqlite_last_insert_rowid()</b> API function.</td>
   926    934   </tr>
   927    935   
................................................................................
   965    973   <td valign="top">Return the argument with the minimum value.  Arguments
   966    974   may be strings in addition to numbers.  The mminimum value is determined
   967    975   by the usual sort order.  Note that <b>min()</b> is a simple function when
   968    976   it has 2 or more arguments but converts to an aggregate function if given
   969    977   only a single argument.</td>
   970    978   </tr>
   971    979   
          980  +<tr>
          981  +<td valign="top" align="right">nullif(<i>X</i>,<i>Y</i>)</td>
          982  +<td valign="top">Return the first argument if the arguments are different, 
          983  +otherwise return NULL.</td>
          984  +</tr>
          985  +
   972    986   <tr>
   973    987   <td valign="top" align="right">random(*)</td>
   974    988   <td valign="top">Return a random integer between -2147483648 and
   975    989   +2147483647.</td>
   976    990   </tr>
   977    991   
   978    992   <tr>