SQLite and user-defined functions

Question

What values can a custom SQLite3 function return?

A relevant example is adding a function for regexp- what values will it return to indicate a match or a mismatch? Or should it be invalid?

+3

SK9 Jun 09 '11 at 6:18

2 answers

( SQLite), SQLite3, , MATCH.

0

Benoit 09 . '11 8:14

Donal fellows · Accepted Answer · 2011-06-09T08:40:51+0000

Results are displayed from SQLite3 functions (at C level ) using the function sqlite3_result_int(and its siblings if other types are returned).

void sqlite3_result_int(sqlite3_context*, int);

Report an error with 0 for the second argument and true with 1 (or another non-zero).