Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
190252fee0a86eb6f8c24a2402e36482 |
User & Date: | jplyon 2003-06-08 08:36:34.000 |
Context
2003-06-09
| ||
11:53 | Remove redundant "return" statement from btree_rb.c. (CVS 1016) (check-in: 373d077173 user: drh tags: trunk) | |
2003-06-08
| ||
08:36 | Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) (check-in: 190252fee0 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: 7d3405b95b user: drh tags: trunk) | |
Changes
Changes to www/lang.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 | # # Run this Tcl script to generate the sqlite.html file. # set rcsid {$Id: lang.tcl,v 1.61 2003/06/08 08:36:34 jplyon Exp $} puts {<html> <head> <title>Query Language Understood By SQLite</title> </head> <body bgcolor=white> <h1 align=center> |
︙ | ︙ | |||
900 901 902 903 904 905 906 | <td valign="top" align="right" width=120>abs(<i>X</i>)</td> <td valign="top">Return the absolute value of argument <i>X</i>.</td> </tr> <tr> <td valign="top" align="right">coalesce(<i>X</i>,<i>Y</i>,...)</td> <td valign="top">Return a copy of the first non-NULL argument. If | | > > > > > > > > | 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 | <td valign="top" align="right" width=120>abs(<i>X</i>)</td> <td valign="top">Return the absolute value of argument <i>X</i>.</td> </tr> <tr> <td valign="top" align="right">coalesce(<i>X</i>,<i>Y</i>,...)</td> <td valign="top">Return a copy of the first non-NULL argument. If all arguments are NULL then NULL is returned. There must be at least 2 arguments.</td> </tr> <tr> <a name="globFunc"></a> <td valign="top" align="right">glob(<i>X</i>,<i>Y</i>)</td> <td valign="top">This function is used to implement the "<b>Y GLOB X</b>" syntax of SQLite. The <a href="c_interface.html#cfunc">sqlite_create_function()</a> interface can be used to override this function and thereby change the operation of the <a href="#glob">GLOB</a> operator.</td> </tr> <tr> <td valign="top" align="right">ifnull(<i>X</i>,<i>Y</i>)</td> <td valign="top">Return a copy of the first non-NULL argument. If both arguments are NULL then NULL is returned. This behaves the same as <b>coalesce()</b> above.</td> </tr> <tr> <td valign="top" align="right">last_insert_rowid()</td> <td valign="top">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 <b>sqlite_last_insert_rowid()</b> API function.</td> </tr> |
︙ | ︙ | |||
965 966 967 968 969 970 971 972 973 974 975 976 977 978 | <td valign="top">Return the argument with the minimum value. Arguments may be strings in addition to numbers. The mminimum value is determined by the usual sort order. Note that <b>min()</b> is a simple function when it has 2 or more arguments but converts to an aggregate function if given only a single argument.</td> </tr> <tr> <td valign="top" align="right">random(*)</td> <td valign="top">Return a random integer between -2147483648 and +2147483647.</td> </tr> <tr> | > > > > > > | 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 | <td valign="top">Return the argument with the minimum value. Arguments may be strings in addition to numbers. The mminimum value is determined by the usual sort order. Note that <b>min()</b> is a simple function when it has 2 or more arguments but converts to an aggregate function if given only a single argument.</td> </tr> <tr> <td valign="top" align="right">nullif(<i>X</i>,<i>Y</i>)</td> <td valign="top">Return the first argument if the arguments are different, otherwise return NULL.</td> </tr> <tr> <td valign="top" align="right">random(*)</td> <td valign="top">Return a random integer between -2147483648 and +2147483647.</td> </tr> <tr> |
︙ | ︙ |