On Mon, Feb 18, 2019 at 9:58 AM Arun - Siara Logics (cc) <a...@siara.cc> wrote:
> [...]. Is it possible to read specific row(s) from a table within same > db (using row ids) from inside a User defined Deterministic scalar function > (C API)? > Yes it is possible, but then your UDF is unlikely to be *Deterministic*. The latter means the function always returns the same result given inputs. If you have to lookup rows in some table, mostly likely based on inputs, then those rows are other indirect inputs of some kind, so determinism is unlikely (although not possible, depends). SQLite statements "can" nest. Whether that's a good idea, it depends :). --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users