Results of 1 - 10 of about 32 for scalar (0.006 sec.)
- Complete API – DuckDB 15835
- 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
...t_row_invalid ( uint64_t * validity , idx_t row ); void duckdb_validity_set_row_valid ( uint64_t * validity , idx_t row ); Scalar Functions duckdb_scalar_function duckdb_create_scalar_function (); void duckdb_destroy_scalar_function ( duckdb_scalar_fun...ction * scalar_function ); void duckdb_scalar_function_set_name ( duckdb_scalar_function scalar_function , const char * name ); void duck...db_scalar_function_set_varargs ( duckdb_scalar_function scalar_function , duckdb_logical_type type ); void duckdb_scalar_function_se... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Functions – DuckDB 10423
- 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
...function call: Parser Error: syntax error at or near "(" Limitations Function chaining via the dot operator is limited to scalar functions and is not supported for table functions. For example, the following call returns a Parser Error : SELECT * FROM..., function_type , return_type , parameters , parameter_types , description FROM duckdb_functions () WHERE function_type = 'scalar' AND function_name LIKE 'b%' ORDER BY function_name ; function_name function_type return_type parameters parameter_types d...escription bar scalar VARCHAR [x, min, max, width] [DOUBLE, DOUBLE, DOUBLE, DOUBLE] Draws a band whose width is proportional to (x - min) and eq... - https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
- Subqueries – DuckDB 10149
- 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
...s are usually based on SELECT ... FROM , but in DuckDB other query constructs such as PIVOT can also appear as a subquery. Scalar Subquery Scalar subqueries are subqueries that return a single value. They can be used anywhere where an expression can be...used. If a scalar subquery returns more than a single value, an error is raised (unless scalar_subquery_error_on_multiple_rows is set to fal...); We can run the following query to obtain the minimum grade: SELECT min ( grade ) FROM grades ; min(grade) 7 By using a scalar subquery in the WHERE clause, we can figure out for which course this grade was obtained: SELECT course FROM grades WHERE... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- CREATE MACRO Statement – DuckDB 9166
- 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
...ap Live Demo Documentation / SQL / Statements Copy Markdown CREATE MACRO Statement The CREATE MACRO statement can create a scalar or table macro (function) in the catalog. A macro may only be a single SELECT statement (similar to a VIEW ), but it has t...he benefit of accepting parameters. For a scalar macro, CREATE MACRO is followed by the name of the macro, and optionally parameters within a set of parentheses. The keywo...rd AS is next, followed by the text of the macro. By design, a scalar macro may only return a single value. For a table macro, the syntax is similar to a scalar macro except AS is replaced wit... - https://man.mtool.work/duckdb/1.3/sql/statements/create_macro.html
- Lambda Functions – DuckDB 8892
- 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
...be possible. Lambda functions enable the use of more complex and flexible expressions in queries. DuckDB supports several scalar functions that operate on LIST s and accept lambda functions as parameters in the form lambda parameter1 , parameter2 , .....id lambda functions: lambda param : param > 1 lambda s : contains ( concat ( s , 'DB' ), 'duck' ) lambda acc , x : acc + x Scalar Functions That Accept Lambda Functions Name Description list_transform(list, lambda(x)) Returns a list that is the result...st_filter examples . list_reduce(list, lambda(x, y)[, initial_value]) Reduces all elements of the input list into a single scalar value by executing the lambda function on a running result and the next list element. The lambda function has an optional... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- C++ API – DuckDB 8506
- 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
...The UDF API allows the definition of user-defined functions. It is exposed in duckdb:Connection through the methods: CreateScalarFunction() , CreateVectorizedFunction() , and variants. These methods created UDFs into the temporary schema ( TEMP_SCHEMA...) of the owner connection that is the only one allowed to use and change them. CreateScalarFunction The user can code an ordinary scalar function and invoke the CreateScalarFunction() to register and afterward use...the UDF in a SELECT statement, for instance: bool bigger_than_four ( int value ) { return value > 4 ; } connection . CreateScalarFunction < bool , int > ( "bigger_than_four" , & bigger_than_four ); connection . Query ( "SELECT bigger_than_four(i) FROM... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
- TRY expression – DuckDB 8183
- 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
...L / Expressions Copy Markdown TRY expression The TRY expression ensures that errors caused by the input rows in the child (scalar) expression result in NULL for those rows, instead of causing the query to throw an error. The TRY expression was inspired...INTEGER ) AS x FROM cte ; x 123 NULL 235 Limitations TRY cannot be used in combination with a volatile function or with a scalar subquery . For example: SELECT TRY ( random ()) Binder Error: TRY can not be used in combination with a volatile function...関連キーワード expression Without errors rows scalar return they Casting Conversion convert cannot used combination volatile Documentation Expressions Copy Markdown ensures ca... - https://man.mtool.work/duckdb/1.3/sql/expressions/try.html
- JSON Processing Functions – DuckDB 8119
- 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
...be used if the string is stored as the JSON logical type. These functions supports the same two location notations as JSON Scalar functions . Function Alias Operator Description json_exists(json, path) Returns true if the supplied path exists in the js...of VARCHAR . json_value(json, path) Extracts JSON from json at the given path . If the json at the supplied path is not a scalar value, it will return NULL . Note that the arrow operator -> , which is used for JSON extracts, has a low precedence as it...xtracted_list FROM example ) SELECT extracted_list [ 1 ] AS family , extracted_list [ 2 ] AS species FROM extracted ; JSON Scalar Functions The following scalar JSON functions can be used to gain information about the stored JSON values. With the excep... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Unnesting – DuckDB 7958
- 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
...= 2 ); The unnest special function is used to unnest lists or structs by one level. The function can be used as a regular scalar function, but only in the SELECT clause. Invoking unnest with the recursive parameter will unnest lists and structs of mul...lt: SELECT unnest ([]); Empty result: SELECT unnest ( NULL ); Using unnest on a list emits one row per list entry. Regular scalar expressions in the same SELECT clause are repeated for every emitted row. When multiple lists are unnested in the same SEL...rsive rows structs Unnest struct columns unnesting clause parameter Empty entry unnested fully within Recursive using used scalar multiple 関連するページ List Type SELECT Clause Pivot Internals Struct Data Type Struct Functions Set Operations See this... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/unnest.html
- Sharing Macros – DuckDB 7684
- 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
...Markdown Sharing Macros DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we defined a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and...tent issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Sharing a Scalar Macro Sharing a Table Macro... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
DuckDB 1.3 Documentation / man.mtool.work