Re: [sqlite] Personal function and parameter evaluation.

2014-01-06 Thread trash Spam
No, I did not mean anything special. This is an example. The query may not work there is no table so no type. 2014/1/6 Igor Tandetnik <i...@tandetnik.org> > On 1/6/2014 3:33 PM, trash Spam wrote: > >> void myFunc( sqlite3_context* ctx, int nArgs, sqli

[sqlite] Personal function and parameter evaluation.

2014-01-06 Thread trash Spam
Hi, void myFunc( sqlite3_context* ctx, int nArgs, sqlite3_value** values ) { // const char* expr = (const char*)sqlite3_value_text( values[ 0 ] ): // } select myFunc( col1 + col2 ) ; The expression "col1 + col2" is evaluated when i call sqlite3_value_text or before the

[sqlite] Personal function and parameter evaluation.

2014-01-06 Thread trash Spam
Hi, void myFunc( sqlite3_context* ctx, int nArgs, sqlite3_value** values ) { // const char* expr = (const char*)sqlite3_value_text( values[ 0 ] ): // } select myFunc( col1 + col2 ) ; The expression col1 + col2 is evaluated when i call sqlite3_value_text or before the call

Re: [sqlite] Personal function and parameter evaluation.

2014-01-06 Thread trash Spam
No, I did not mean anything special. This is an example. The query may not work there is no table so no type. 2014/1/6 Igor Tandetnik i...@tandetnik.org On 1/6/2014 3:33 PM, trash Spam wrote: void myFunc( sqlite3_context* ctx, int nArgs, sqlite3_value** values ) { // const

Re: [sqlite] aggregate and index.

2012-01-10 Thread trash Spam
2012/1/10 Richard Hipp <d...@sqlite.org> > On Tue, Jan 10, 2012 at 12:56 PM, trash Spam <wwwtrashs...@gmail.com> > wrote: > > SELECT (SELECT min(col3) FROM t1)+1; > Works, thank you. > > sqlite-users mailing list > > sqlite-users@sqlite.org > > ht

Re: [sqlite] aggregate and index.

2012-01-10 Thread trash Spam
2012/1/10 Richard Hipp d...@sqlite.org On Tue, Jan 10, 2012 at 12:56 PM, trash Spam wwwtrashs...@gmail.com wrote: SELECT (SELECT min(col3) FROM t1)+1; Works, thank you. sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users