diff options
| author | drh <drh@noemail.net> | 2006-03-02 03:02:48 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2006-03-02 03:02:48 +0000 |
| commit | d589a92a26a7a74ee7c9770157f34e4ed7f0d774 (patch) | |
| tree | 2aac4584c297bc9f75984764dbf5dc72ba92f9d8 /src/func.c | |
| parent | e3dd8bb5be645366bd96e1debce1979823fc7709 (diff) | |
| download | sqlite-d589a92a26a7a74ee7c9770157f34e4ed7f0d774.tar.gz sqlite-d589a92a26a7a74ee7c9770157f34e4ed7f0d774.zip | |
Change the ROUND() function to return a REAL value instead of TEXT.
Ticket #1699. (CVS 3116)
FossilOrigin-Name: 9dbadfb2111f7d7f971e1832db3992ed5851d8b1
Diffstat (limited to 'src/func.c')
| -rw-r--r-- | src/func.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/func.c b/src/func.c index e365cc435..951365115 100644 --- a/src/func.c +++ b/src/func.c @@ -16,7 +16,7 @@ ** sqliteRegisterBuildinFunctions() found at the bottom of the file. ** All other code has file scope. ** -** $Id: func.c,v 1.124 2006/02/23 21:51:13 drh Exp $ +** $Id: func.c,v 1.125 2006/03/02 03:02:48 drh Exp $ */ #include "sqliteInt.h" #include <ctype.h> @@ -201,10 +201,10 @@ static void roundFunc(sqlite3_context *context, int argc, sqlite3_value **argv){ if( n>30 ) n = 30; if( n<0 ) n = 0; } - if( SQLITE_NULL==sqlite3_value_type(argv[0]) ) return; + if( sqlite3_value_type(argv[0])==SQLITE_NULL ) return; r = sqlite3_value_double(argv[0]); sqlite3_snprintf(sizeof(zBuf),zBuf,"%.*f",n,r); - sqlite3_result_text(context, zBuf, -1, SQLITE_TRANSIENT); + sqlite3_result_double(context, atof(zBuf)); } /* |