Search Result: dont - DuckDB 2.0 全文検索

Python Function API 9414: You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth ... not desired, you need to explicitly set this parameter to "special" . import duckdb from duckdb.sqltypes import BIGINT def dont_intercept_null(x): return 5 duckdb.create_function("dont_intercept", dont_intercept_null, [BIGINT], BIGINT) res = duckdb.s ... ql("SELECT dont_intercept(NULL)").fetchall() print(res) [(None,)] With null_handling="special" : import duckdb from duckdb.sqltypes import ... BIGINT def dont_intercept_null(x): return 5 duckdb.create_function("dont_intercept_special", dont_intercept_null, [BIGINT], BIGINT, null_h ...; https://man.mtool.work/duckdb/2.0/clients/python/function.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work