[sqlite] for function extension in sqlite3

[dark0s dark0s]

Hi all, I'd like write extension for sqlite3 creating soundex function like 
below:

void soundex() {
...
...
}


int main(int argc, char* argv[]) {

  int rc;
  sqlite3* db;

  rc = sqlite3_open("dbforext.db",&db);
  if (rc) {
    fprintf(stderr, "E' impossibile aprire il file %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    exit(1);
  }

  sqlite3_create_function(db, "soundex", 1, SQLITE_UTF8, NULL, soundex, NULL, 
NULL);

  sqlite3_close(db);

  return 0;

}

but I have some questions:

1) The output of gcc is:

bash-3.1# gcc -lsqlite3 labsinf.c -o inf
labsinf.c: In function 'main':
labsinf.c:61: warning: passing argument 6 of 'sqlite3_create_function' from 
incompatible pointer type

2) I must pass to soundex parameters for db connection, for my processing or 
both?

3) I need a little example of function creating in sqlite3.

Thank you
savio
       
---------------------------------
Inviato da Yahoo! Mail.
La casella di posta intelligente.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users