Results of 1 - 10 of about 36 for Logical (0.005 sec.)
- Types 14374
- 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
...that can potentially be nested. Types in the C API are modeled using an enum ( duckdb_type ) and a complex class ( duckdb_logical_type ). For most primitive types, e.g., integers or varchars, the enum is sufficient. For more complex types, such as list...s, structs or decimals, the logical type must be used. typedef enum DUCKDB_TYPE { DUCKDB_TYPE_INVALID = 0, DUCKDB_TYPE_BOOLEAN = 1, DUCKDB_TYPE_TINYINT = 2, D...duckdb_type; Functions The enum type of a column in the result can be obtained using the duckdb_column_type function. The logical type of a column can be obtained using the duckdb_column_logical_type function. duckdb_value The duckdb_value functions wi... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Complete API 13328
- 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
...duckdb_result * result , idx_t col ); duckdb_statement_type duckdb_result_statement_type ( duckdb_result result ); duckdb_logical_type duckdb_column_logical_type ( duckdb_result * result , idx_t col ); duckdb_arrow_options duckdb_result_get_arrow_optio..., idx_t index ); duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_logical_type duckdb_param_logical_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_state duckdb_cle...onst char * duckdb_prepared_statement_column_name ( duckdb_prepared_statement prepared_statement , idx_t col_idx ); duckdb_logical_type duckdb_prepared_statement_column_logical_type ( duckdb_prepared_statement prepared_statement , idx_t col_idx ); duckd... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Prepared Statements 10048
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
..., idx_t index ); duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_logical_type duckdb_param_logical_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_state duckdb_cle...onst char * duckdb_prepared_statement_column_name ( duckdb_prepared_statement prepared_statement , idx_t col_idx ); duckdb_logical_type duckdb_prepared_statement_column_logical_type ( duckdb_prepared_statement prepared_statement , idx_t col_idx ); duckd...prepared_statement : The prepared statement. param_idx : The parameter index. Return Value The parameter type duckdb_param_logical_type Returns the logical type for the parameter at the given index. Returns nullptr if the parameter index is out of range... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Overview of DuckDB Internals 9255
- Tip For a detailed explanation of DuckDB internals, see the Design and Implementation of DuckDB Internals ("DiDi") library entry. On this page is a brief description of the internals of the DuckDB engine. Parser The parser converts a query
...s happen: SQLStatement → BoundStatement QueryNode → BoundQueryNode TableRef → BoundStatement ParsedExpression → Expression Logical Planner The logical planner creates LogicalOperator nodes from the bound statements. In this phase, the actual logical que...ry tree is created. Optimizer After the logical planner has created the logical query tree, the optimizers are run over that query tree to create an optimized query plan....ewrites large static IN clauses to a MARK join or INNER join. Column Binding Resolver The column binding resolver converts logical BoundColumnRefExpression nodes that refer to a column of a specific table into BoundReferenceExpression nodes that refer t... - https://man.mtool.work/duckdb/2.0/internals/overview.html
- Values 8685
- 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
...imestamp_ns duckdb_get_timestamp_ns ( duckdb_value val ); duckdb_interval duckdb_get_interval ( duckdb_value val ); duckdb_logical_type duckdb_get_value_type ( duckdb_value val ); duckdb_blob duckdb_get_blob ( duckdb_value val ); duckdb_bit duckdb_get_b...d ( duckdb_value val ); char * duckdb_get_varchar ( duckdb_value value ); duckdb_value duckdb_create_struct_value ( duckdb_logical_type type , duckdb_value * values ); duckdb_value duckdb_create_list_value ( duckdb_logical_type type , duckdb_value * val...ues , idx_t value_count ); duckdb_value duckdb_create_array_value ( duckdb_logical_type type , duckdb_value * values , idx_t value_count ); duckdb_value duckdb_create_map_value ( duckdb_logical_type map_ty... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Query 8273
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...duckdb_result * result , idx_t col ); duckdb_statement_type duckdb_result_statement_type ( duckdb_result result ); duckdb_logical_type duckdb_column_logical_type ( duckdb_result * result , idx_t col ); duckdb_arrow_options duckdb_result_get_arrow_optio...to fetch the statement type from. Return Value duckdb_statement_type value or DUCKDB_STATEMENT_TYPE_INVALID duckdb_column_logical_type Returns the logical column type of the specified column. The return type of this call should be destroyed with duckdb..._destroy_logical_type . Returns NULL if the column is out of range. Syntax duckdb_logical_type duckdb_column_logical_type ( duckdb_result *... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
- Logical Operators 8003
- The following logical operators are available: AND , OR and NOT . SQL uses a three-valued logic system with true , false and NULL . Note that logical operators involving NULL do not always evaluate to NULL . For example, NULL AND false will
... - https://man.mtool.work/duckdb/2.0/sql/expressions/logical_operators.html
- Table Functions 7972
- 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_
...e_function , const char * name ); void duckdb_table_function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); void duckdb_table_function_add_named_parameter ( duckdb_table_function table_function , const char * name , d...uckdb_logical_type type ); void duckdb_table_function_set_extra_info ( duckdb_table_function table_function , void * extra_info , duckdb...db_client_context * out_context ); void duckdb_bind_add_result_column ( duckdb_bind_info info , const char * name , duckdb_logical_type type ); idx_t duckdb_bind_get_parameter_count ( duckdb_bind_info info ); duckdb_value duckdb_bind_get_parameter ( duc... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Caveats 7892
- Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is based on raw text comparison, while in other cases, it uses logical content comparison. The following query retur
...ns true for all fields: SELECT a != b, -- Space is part of physical JSON content. Despite equal logical content, values are treated as not equal. c != d, -- Same. c[0] = d[0], -- Equality because space was removed from physica... - https://man.mtool.work/duckdb/2.0/data/json/caveats.html
- Metrics 7892
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...it Description parser.total_time double seconds Time spent parsing the SQL query planner Metrics Metrics on generating the logical plan. Name Type Unit Description planner.binding_time double seconds Time spent binding the logical plan planner.total_tim...e double seconds Time spent generating the logical plan physical_planner Metrics Metrics on generating the physical plan. Name Type Unit Description physical_planner.column_...binding double seconds Time spent binding the columns in the logical plan to physical columns physical_planner.create_plan double seconds Time spent creating the physical plan physical_planne... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
DuckDB 2.0 Documentation / man.mtool.work