[sqlite] How to create operator "IS Empty" similar to "IS NULL"

[Alexey Pechnikov]

Hello!

Please see ticket 
http://www.sqlite.org/src/info/15e11a2c87

Function IFEmpty may be simple:

static void ifemptyFunc(
  sqlite3_context *context,
  int argc,
  sqlite3_value **argv
){
  int i;
  for(i=0; i<argc; i++){
    if( SQLITE_NULL!=sqlite3_value_type(argv[i]) && 
0!=sqlite3_column_bytes(argv[i]) ){
      sqlite3_result_value(context, argv[i]);
      break;
    }
  }
}


But construction "... IS Empty" produce some difficults to me.

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users