Results of 1 - 10 of about 95 for return (0.008 sec.)
- Complete API – DuckDB 12612
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...aming ( duckdb_result result ); idx_t duckdb_result_chunk_count ( duckdb_result result ); duckdb_result_type duckdb_result_return_type ( duckdb_result result ); Safe Fetch Functions bool duckdb_value_boolean ( duckdb_result * result , idx_t col , idx_t...ction_add_parameter ( duckdb_scalar_function scalar_function , duckdb_logical_type type ); void duckdb_scalar_function_set_return_type ( duckdb_scalar_function scalar_function , duckdb_logical_type type ); void duckdb_scalar_function_set_extra_info ( d..._parameter ( duckdb_aggregate_function aggregate_function , duckdb_logical_type type ); void duckdb_aggregate_function_set_return_type ( duckdb_aggregate_function aggregate_function , duckdb_logical_type type ); void duckdb_aggregate_function_set_funct... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Values – DuckDB 11506
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nated string Syntax duckdb_value duckdb_create_varchar ( const char * text ); Parameters text : The null-terminated string Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_varchar_length Creates a value from a st...kdb_create_varchar_length ( const char * text , idx_t length ); Parameters text : The text length : The length of the text Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_bool Creates a value from a boolean Synt...ax duckdb_value duckdb_create_bool ( bool input ); Parameters input : The boolean value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_int8 Creates a value from an int8_t (a t... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Types – DuckDB 10966
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...mple, it is no problem to use duckdb_value_double on a column of type duckdb_value_int32 . The value will be auto-cast and returned as a double. Note that in certain cases the cast may fail. For example, this can happen if we request a duckdb_value_int...8 and the value does not fit within an int8 value. In this case, a default value will be returned (usually 0 or nullptr ). The same default value will also be returned if the corresponding value is NULL . The duckdb_va...aming ( duckdb_result result ); idx_t duckdb_result_chunk_count ( duckdb_result result ); duckdb_result_type duckdb_result_return_type ( duckdb_result result ); Date Time Timestamp Helpers duckdb_date_struct duckdb_from_date ( duckdb_date date ); duckd... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Utility Functions – DuckDB 10848
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whether or not we can implicitly cast from the typ...ckpoint(database) Synchronize WAL with file for (optional) database without interrupting transactions. coalesce(expr, ...) Return the first expression that evaluates to a non- NULL value. Accepts 1 or more parameters. Each expression can be a column, l...iteral value, function result, or many others. constant_or_null(arg1, arg2) If arg2 is NULL , return NULL . Otherwise, return arg1 . count_if(x) Aggregate function; rows contribute 1 if x is true or a non-zero number, else... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Python Function API – DuckDB 10190
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...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. Here is an example using a Python function that calls a third-party library. import duckdb from...duckdb.typing import * from faker import Faker def generate_random_name (): fake = Faker () return fake . name () duckdb . create_function ( "random_name" , generate_random_name , [], VARCHAR ) res = duckdb . sql ( "SELEC...ection. Here is the syntax: import duckdb con = duckdb . connect () con . create_function ( name , function , parameters , return_type ) The create_function method takes the following parameters: name A string representing the unique name of the UDF wi... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- ADBC Client – DuckDB 9189
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...bc_connection, &adbc_error) A set of functions that retrieve metadata about the database. In general, these functions will return Arrow objects, specifically an ArrowArrayStream. Function name Description Arguments Example ConnectionGetObjects Get a hi...int64_t*, AdbcError*) AdbcStatementExecuteQuery(&adbc_statement, &arrow_stream, &rows_affected, &adbc_error) StatementPrepare Turn this statement into a prepared statement to be executed multiple times. (AdbcStatement*, AdbcError*) AdbcStatementPrepare...e () schema := arrow . NewSchema ([] arrow . Field {{ Name : "column1" , Type : arrow . PrimitiveTypes . Float64 }}, nil ) return array . NewRecord ( schema , [] arrow . Array { col }, int64 ( col . Len ())) } type DuckDBSQLRunner struct { ctx context... - https://man.mtool.work/duckdb/1.3/clients/adbc.html
- Node.js API – DuckDB 8531
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...d .arrowIPCStream(sql, …params, callback) ⇒ .each(sql, …params, callback) ⇒ void .stream(sql, …params) .register_udf(name, return_type, fun) ⇒ void .prepare(sql, …params, callback) ⇒ Statement .exec(sql, …params, callback) ⇒ void .register_udf_bulk(nam...e, return_type, callback) ⇒ void .unregister_udf(name, return_type, callback) ⇒ void .register_buffer(name, array, force, callback)..., callback) ⇒ void .arrowIPCStream(sql, …params, callback) ⇒ void .exec(sql, …params, callback) ⇒ void .register_udf(name, return_type, fun) ⇒ this .register_buffer(name) ⇒ this .unregister_buffer(name) ⇒ this .unregister_udf(name) ⇒ this .registerRepl... - https://man.mtool.work/duckdb/1.3/clients/nodejs/reference.html
- Map Functions – DuckDB 8228
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...rmat Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Map Functions Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list...key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging the input maps . On key collision the value is taken from the last map with that key. map_cont...p contains a given key-value pair. map_contains_value(map, value) Checks if a map contains a given value. map_entries(map) Return a list of struct(k, v) for each key-value pair in the map. map_extract(map, key) Return the value for a given key as a lis... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Table Functions – DuckDB 7807
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...r ( duckdb_function_info info , const char * error ); duckdb_create_table_function Creates a new empty table function. The return value should be destroyed with duckdb_destroy_table_function . Return Value The table function object. Syntax duckdb_table...nit function and a main function. If the function is incomplete or a function with this name already exists DuckDBError is returned. Syntax duckdb_state duckdb_register_table_function ( duckdb_connection con , duckdb_table_function function ); Paramete...rs con : The connection to register it in. function : The function pointer Return Value Whether or not the registration was successful. duckdb_bind_get_extra_info Retrieves the extra info of the function... - https://man.mtool.work/duckdb/1.3/clients/c/table_functions.html
- Window Functions – DuckDB 7767
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...nk of the current row without gaps; this function counts peer groups. first_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is the first row (with a non-null value of expr if IGNORE NULLS is set) of the window fram...e. lag(expr[, offset[, default]][ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is offset rows (among rows with a non-null value of expr if IGNORE NULLS is set) before th...e current row within the window frame; if there is no such row, instead return default (which must be of the Same type as expr ). Both offset and default are evaluated with respect to the current row.... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
DuckDB 1.3 Documentation / man.mtool.work