>Is there a way to write my own coalesce-Function (or indeed any >function) so that its result has an affinity? The documentation of the >sqlite3_result_* family of functions suggests not.
No. But you can cast the result to whatever type you wish: cast(coalesce(a, 5) as TEXT) and it will then have a type affinity. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users