Index: Doc/Extra/dbfactorysupport.html ================================================================== --- Doc/Extra/dbfactorysupport.html +++ Doc/Extra/dbfactorysupport.html @@ -95,11 +95,11 @@ <DbProviderFactories> <remove invariant="System.Data.SQLite"/> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, - Version=1.0.54.0, Culture=neutral, + Version=1.0.55.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139"/> </DbProviderFactories> </system.data> </configuration> Index: Doc/Extra/lang_expr.html ================================================================== --- Doc/Extra/lang_expr.html +++ Doc/Extra/lang_expr.html @@ -3,10 +3,16 @@ expression + @@ -357,22 +363,138 @@ be written in C and added to the database engine using the sqlite3_create_function() API.

- + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Compute the soundex encoding of the string X. The string "?000" is + returned if the argument is NULL. + Return the version string for the SQLite library that is running. Example: "3.6.0" + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ abs(X) Return the absolute value of argument X.
+ acos(X) + A mathematical function that returns the angle, in radians, whose cosine is the + specified double expression
+ acosh(X) + Inverse hyperbolic cosine
+ asin(X) + Returns the angle, in radians, whose sine is the specified double + expression
+ asinh(X) + Inverse hyperbolic sine
+ atan(X) + Returns the angle in radians whose tangent is a specified double + expression
+ atanh(X) + Inverse hyperbolic tangent
+ atn2(X,Y)
+ atan2(X,Y)
+ Returns the angle, in radians, between the positive x-axis and the ray from the + origin to the point (y, x), where x and y are the values of the two specified + double expressions
+ ceil(X)
+ ceiling(X)
+ Returns the smallest integer greater than, or equal to, the specified numeric + expression
+ charindex(X,Y[,Z]) + Returns the 1-based position of the string X inside the string Y + starting at position Z.  Returns 0 if not X is not found + within Y.
coalesce(X,Y,...) 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.
+ cos(X) + a mathematical function that returns the trigonometric cosine of the specified + angle, in radians, in the specified expression
+ cosh(X) + Hyperbolic cosine
+ cot(X) + A mathematical function that returns the trigonometric cotangent of the + specified angle, in radians, in the specified double expression
+ coth(X) + Hyperbolic cotangent
+ difference(X,Y) + Returns an integer value that indicates the difference between the SOUNDEX + values of two character expressions
+ degrees(X) + Converts radians to degrees
+ exp(X) + Returns the exponential value of the specified expression
+ floor(X) + Returns the largest integer less than or equal to the specified numeric + expression
glob(X,Y) @@ -394,10 +516,22 @@ 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.
+ last_rows_affected() + Returns the number of rows affected by the last insert/update operation
+ leftstr(X,Y) + Returns the leftmost Y characters in string X.
length(X) Return the string length of X in characters. If SQLite is configured to support @@ -426,10 +560,22 @@ point Y. The result is a NULL. If Y is omitted then the default entry point of sqlite3_extension_init is used. This function raises an exception if the extension fails to load or initialize correctly.
+ log(X) + Returns the natural logarithm of the specified double expression
+ log10(X) + Returns the base-10 logarithm of the specified double expression
lower(X) Return a copy of string X will all characters converted to lower case. The @@ -458,10 +604,50 @@ nullif(X,Y) Return the first argument if the arguments are different, otherwise return NULL.
+ padc(X,Y) + Pads the given string X on the left and the right with spaces until it is + the specified length Y
+ padl(X,Y) + Pads the given string X on the left with spaces until it is the specified + length Y
+ padr(X,Y) + Pads the given string X on the right with spaces until it is the + specified length Y
+ pi + Returns the value of pi
+ power(X,Y) + Returns the value of the specified expression X to the specified power + Y
+ proper(X) + Proper-case the given string X
quote(X) This routine returns a string which is the value of its argument suitable for inclusion @@ -470,37 +656,93 @@ implementation of VACUUM uses this function. The function is also useful when writing triggers to implement undo/redo functionality.
+ radians(X) + Converts degrees to radians
random(*) Return a pseudo-random integer between -9223372036854775808 and +9223372036854775807.
+ replicate(X,Y) + Return the concatenation of string X repeated Y times
+ reverse(X) + Returns the string X reversed
+ rightstr(X,Y) + Returns the right-most Y characters in string X.
round(X)
round(X,Y)
Round off the number X to Y digits to the right of the decimal point. If the Y argument is omitted, 0 is assumed.
+ sign(X) + Returns the positive (+1), zero (0), or negative (-1) sign of the specified + expression
+ sin(X) + Returns the trigonometric sine of the specified angle, in radians, and in an + approximate numeric, double, expression
soundex(X) - Compute the soundex encoding of the string X. The string "?000" is returned - if the argument is NULL. This function is omitted from SQLite by default. It is - only available the -DSQLITE_SOUNDEX=1 compiler option is used when SQLite is built.
sqlite_version(*) - Return the version string for the SQLite library that is running. Example: "2.8.0"
+ sqrt(X) + Returns the square root of the specified value
+ square(X) + Returns the square of the specified value
+ strfilter(X,Y) + Given a source string X and the characters to filter Y, returns + X with all characters not found in Y removed.
substr(X,Y,Z) @@ -508,10 +750,22 @@ and which is Z characters long. The left-most character of X is number 1. If Y is negative the the first character of the substring is found by counting from the right rather than the left. If SQLite is configured to support UTF-8, then characters indices refer to actual UTF-8 characters, not bytes.
+ tan(X) + Returns the tangent of the input expression
+ tanh(X) + Hyperbolic tangent
typeof(X) Return the type of the expression X. The only return values are "null", "integer", @@ -563,25 +817,56 @@ The first form return a count of the number of times that X is not NULL in a group. The second form (with no argument) returns the total number of rows in the group.
+ lower_quartile(X) + Returns the lower quartile of the given numbers in the set
max(X) Return the maximum value of all values in the group. The usual sort order is used to determine the maximum.
+ median(X) + Returns the middle value in a set of ordered numbers. (The medial value is + unlike the mean value, which is the sum of a set of numbers divided by the count + of numbers in the set). The median value is determined by choosing the smallest + value such that at least half of the values in the set are no greater than the + chosen value. If the number of values within the set is odd, the median value + corresponds to a single value. If the number of values within the set is even, + the median value corresponds to the sum of the two middle values divided by two.
min(X) Return the minimum non-NULL value of all values in the group. The usual sort order is used to determine the minimum. NULL is only returned if all values in the group are NULL.
+ mode(X) + Computes the most frequently occurring value in a sample set
+ stdev(X) + Returns the statistical standard deviation of all values in the specified + expression
sum(X)
total(X)
@@ -602,10 +887,16 @@ Sum() will throw an "integer overflow" exception if all inputs are integers or NULL and an integer overflow occurs at any point during the computation. Total() never throws an exception.

+ upper_quartile(X) + Returns the upper quartile of the numbers in the given set


Version History

+

1.0.55.0 - August 6, 2008

+

1.0.54.0 - July 25, 2008