Results of 1 - 10 of about 128 for syntax (0.006 sec.)
- Complete API 12453
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...within the same process. Must be destroyed with 'duckdb_destroy_instance_cache'. Return Value The database instance cache. Syntax duckdb_instance_cache duckdb_create_instance_cache ( ); duckdb_get_or_create_from_cache Creates a new database instance in...the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database...BError on failure. duckdb_destroy_instance_cache Destroys an existing database instance cache and de-allocates its memory. Syntax void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance ca... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Values 11134
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...tring ( duckdb_value value ); duckdb_destroy_value Destroys the value and de-allocates all memory allocated for that type. Syntax void duckdb_destroy_value ( duckdb_value * value ); Parameters value : The value to destroy. duckdb_create_varchar Creates...a value from a null-terminated string Syntax duckdb_value duckdb_create_varchar ( const char * text ); Parameters text : The null-terminated string Return Value The va...lue. This must be destroyed with duckdb_destroy_value . duckdb_create_varchar_length Creates a value from a string Syntax duckdb_value duckdb_create_varchar_length ( const char * text , idx_t length ); Parameters text : The text length : The le... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Types 10304
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...ed with the legacy result functions). Use duckdb_result_chunk_count to figure out how many chunks there are in the result. Syntax duckdb_data_chunk duckdb_result_get_chunk ( duckdb_result result , idx_t chunk_index ); Parameters result : The result obj...This method is scheduled for removal in a future release. Checks if the type of the internal result is StreamQueryResult. Syntax bool duckdb_result_is_streaming ( duckdb_result result ); Parameters result : The result object to check. Return Value Whe...notice. This method is scheduled for removal in a future release. Returns the number of data chunks present in the result. Syntax idx_t duckdb_result_chunk_count ( duckdb_result result ); Parameters result : The result object Return Value Number of dat... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Appender 10267
- Appenders are the most efficient way of loading data into DuckDB from within the C interface, and are recommended for fast data loading. The appender is much faster than using prepared statements or individual INSERT INTO statements. Append
...; duckdb_appender_create Creates an appender object. Note that the object must be destroyed with duckdb_appender_destroy . Syntax duckdb_state duckdb_appender_create ( duckdb_connection connection , const char * schema , const char * table , duckdb_app...ckdb_appender_create_ext Creates an appender object. Note that the object must be destroyed with duckdb_appender_destroy . Syntax duckdb_state duckdb_appender_create_ext ( duckdb_connection connection , const char * catalog , const char * schema , cons...ecutes the given query with any data appended to it. Note that the object must be destroyed with duckdb_appender_destroy . Syntax duckdb_state duckdb_appender_create_query ( duckdb_connection connection , const char * query , idx_t column_count , duckd... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Table Functions 10109
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...unction. The return value should be destroyed with duckdb_destroy_table_function . Return Value The table function object. Syntax duckdb_table_function duckdb_create_table_function ( ); duckdb_destroy_table_function Destroys the given table function ob...ject. Syntax void duckdb_destroy_table_function ( duckdb_table_function * table_function ); Parameters table_function : The table funct...ion to destroy duckdb_table_function_set_name Sets the name of the given table function. Syntax void duckdb_table_function_set_name ( duckdb_table_function table_function , const char * name ); Parameters table_functio... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Startup & Shutdown 8705
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
...within the same process. Must be destroyed with 'duckdb_destroy_instance_cache'. Return Value The database instance cache. Syntax duckdb_instance_cache duckdb_create_instance_cache ( ); duckdb_get_or_create_from_cache Creates a new database instance in...the instance cache, or retrieves an existing database instance. Must be closed with 'duckdb_close'. Syntax duckdb_state duckdb_get_or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database...BError on failure. duckdb_destroy_instance_cache Destroys an existing database instance cache and de-allocates its memory. Syntax void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); Parameters instance_cache : The instance ca... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Lambda Functions 8558
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...hat receives the column name. Optionally, a second parameter may be declared that receives the (1-based) column index. The syntax for a lambda expression is: lambda ⟨parameters⟩ : ⟨expression⟩ ⟨parameters⟩ is a comma-separated list of parameter names....tion. You cannot return a lambda function from a macro (but you can invoke a macro in the lambda's expression). Deprecated Syntax Deprecated DuckDB 1.3 deprecated the old lambda single arrow syntax ( x -> x + 1 ) in favor of the Python-style syntax ( l...ambda x : x + 1 ). DuckDB 1.3 also introduced a new setting to configure the lambda syntax. sql SET lambda_syntax = 'default'; SET lambda_syntax = 'enable_single_arrow'; SET lambda_syntax = 'disable_single_arrow';... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- PIVOT Statement 8216
- The PIVOT statement allows distinct values within a column to be separated into their own columns. The values within those new columns are calculated using an aggregate function on the subset of rows that match each distinct value. DuckDB i
...mplements both the SQL Standard PIVOT syntax and a simplified PIVOT syntax that automatically detects the columns to create while pivoting. PIVOT_WIDER may also be use...implemented, see the Pivot Internals site . The UNPIVOT statement is the inverse of the PIVOT statement. Simplified PIVOT Syntax The full syntax diagram is below, but the simplified PIVOT syntax can be summarized using spreadsheet pivot table naming c...his query produces a result that is identical to the one above: PIVOT cities ON year USING first(population); Note The SQL syntax permits FILTER clauses with aggregate functions in the USING clause. In DuckDB, the PIVOT statement currently does not sup... - https://man.mtool.work/duckdb/2.0/sql/statements/pivot.html
- UNPIVOT Statement 7984
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...s the value from the source column). DuckDB implements both the SQL Standard UNPIVOT syntax and a simplified UNPIVOT syntax. Both can utilize a COLUMNS expression to automatically detect the columns to unpivot. PIV...mplemented, see the Pivot Internals site . The PIVOT statement is the inverse of the UNPIVOT statement. Simplified UNPIVOT Syntax The full syntax diagram is below, but the simplified UNPIVOT syntax can be summarized using spreadsheet pivot table naming...VOT (SELECT 42 AS col1, 'woot' AS col2) ON (col1 * 2)::VARCHAR, col2; name value col1 84 col2 woot Simplified UNPIVOT Full Syntax Diagram Below is the full syntax diagram of the UNPIVOT statement. SQL Standard UNPIVOT Syntax The full syntax diagram is... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Vectors 7911
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...t64_t * validity , idx_t row ); duckdb_create_vector Creates a flat vector. Must be destroyed with duckdb_destroy_vector . Syntax duckdb_vector duckdb_create_vector ( duckdb_logical_type type , idx_t capacity ); Parameters type : The logical type of th...he capacity of the vector. Return Value The vector. duckdb_destroy_vector Destroys the vector and de-allocates its memory. Syntax void duckdb_destroy_vector ( duckdb_vector * vector ); Parameters vector : A pointer to the vector. duckdb_vector_get_colu...mn_type Retrieves the column type of the specified vector. The result must be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logical_type duckdb_vector_get_column_type ( duckdb_vector vector ); Parameters vector : The vector get the data fr... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
DuckDB 2.0 Documentation / man.mtool.work