Results of 1 - 10 of about 46 for invalid (0.005 sec.)
- Blob Functions 13440
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...s for to_base64 . decode(blob[, on_error]) Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid UTF-8: 'strict' (default, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore' (removes invalid cha...| decode(blob[, on_error]) | Description | Converts blob to VARCHAR . The optional on_error parameter controls handling of invalid UTF-8: 'strict' (default, throws error), 'replace' (replaces invalid characters with ? ), or 'ignore' (removes invalid cha... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Complete API 13089
- 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
...ow ); void duckdb_validity_set_row_validity ( uint64_t * validity , idx_t row , bool valid ); void duckdb_validity_set_row_invalid ( uint64_t * validity , idx_t row ); void duckdb_validity_set_row_valid ( uint64_t * validity , idx_t row ); Scalar Functi...et_config_flag . In the source code, configuration options are defined in config.cpp . This can fail if either the name is invalid, or if the value provided for the option is invalid. Syntax duckdb_state duckdb_set_config ( duckdb_config config , const...lumn name of the specified column. duckdb_column_type Returns the column type of the specified column. Returns DUCKDB_TYPE_INVALID if the column is out of range. Syntax duckdb_type duckdb_column_type ( duckdb_result * result , idx_t col ); Parameters re... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Prepared Statements 10770
- 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
...arameter name from. duckdb_param_type Returns the parameter type for the parameter at the given index. Returns DUCKDB_TYPE_INVALID if the parameter index is out of range or the statement was not successfully prepared. Syntax duckdb_type duckdb_param_typ...tement ); Parameters statement : The prepared statement. Return Value duckdb_statement_type value or DUCKDB_STATEMENT_TYPE_INVALID duckdb_prepared_statement_column_count Returns the number of columns present in the result of the prepared statement. If a...ny of the column types are invalid, the result will be 1. Syntax idx_t duckdb_prepared_statement_column_count ( duckdb_prepared_statement prepared_statement... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
- Vectors 10404
- 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
...4_t element exists (rounded up). The validity mask has its bit set to 1 if the value is valid, or set to 0 if the value is invalid (i.e., NULL ). The bits of the bitmask can be read directly, or the slower helper method duckdb_validity_row_is_valid can...ow ); void duckdb_validity_set_row_validity ( uint64_t * validity , idx_t row , bool valid ); void duckdb_validity_set_row_invalid ( uint64_t * validity , idx_t row ); void duckdb_validity_set_row_valid ( uint64_t * validity , idx_t row ); duckdb_create...4_t value contains validity for 64 tuples. The bit is set to 1 if the value is valid (i.e., not NULL) or 0 if the value is invalid (i.e., NULL). Validity of a specific value can be obtained like this: idx_t entry_idx = row_idx / 64; idx_t idx_in_entry =... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Configuration 8619
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...et_config_flag . In the source code, configuration options are defined in config.cpp . This can fail if either the name is invalid, or if the value provided for the option is invalid. Syntax duckdb_state duckdb_set_config ( duckdb_config config , const... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- Types 8619
- 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
...e complex types, such as lists, 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, DUCKDB_TYPE_SMALLINT = 3, DUCKDB_TYPE_INTEGER = 4, DUCKDB_TYPE_BIGI...chunks present in the result. duckdb_result_return_type Returns the return_type of the given result, or DUCKDB_RETURN_TYPE_INVALID on error Syntax duckdb_result_type duckdb_result_return_type ( duckdb_result result ); Parameters result : The result obje...uble value to a duckdb_decimal object. If the conversion fails because the double value is too big, or the width/scale are invalid the result will be 0. Syntax duckdb_decimal duckdb_double_to_decimal ( double val , uint8_t width , uint8_t scale ); Param... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Values 8619
- 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
...alues for the struct fields Return Value The struct value, or nullptr, if any child type is DUCKDB_TYPE_ANY or DUCKDB_TYPE_INVALID . duckdb_create_list_value Creates a list value from a child (element) type and an array of values of length value_count ....number of values in the list Return Value The list value, or nullptr, if the child type is DUCKDB_TYPE_ANY or DUCKDB_TYPE_INVALID . duckdb_create_array_value Creates an array value from a child (element) type and an array of values of length value_coun...umber of values in the array Return Value The array value, or nullptr, if the child type is DUCKDB_TYPE_ANY or DUCKDB_TYPE_INVALID . duckdb_create_map_value Creates a map value from a map type and two arrays, one for the keys and one for the values, eac... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Reading and Writing Parquet Files 8268
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...schema. The MAP can be keyed by field-id ( INTEGER ) or by column name ( VARCHAR ). MAP NULL utf8_validation How to handle invalid UTF-8 in string columns. With strict , an error is thrown. With replace , invalid bytes are replaced by ? . With ignore ,... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Extension Distribution 8268
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...n extension binary. Stripping removes or corrupts the appended metadata footer, after which DuckDB reports the metadata as invalid and refuses to load the extension. On some platforms, strip fails outright because the footer extends beyond the binary's...allow_extensions_metadata_mismatch setting. This lets INSTALL and UPDATE EXTENSIONS accept extensions with mismatching or invalid metadata. For LOAD , the setting only takes effect if allow_unsigned_extensions is also enabled: SET allow_unsigned_extens... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Utility Functions 8268
- Scalar Utility Functions The functions 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) Whet
...bytes(string) Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on invalid input. pg_typeof(expression) Returns the lower case name of the data type of the result of the expression. For PostgreSQL...b pattern) as a VARCHAR . The file content is first validated to be valid UTF-8. If read_text attempts to read a file with invalid UTF-8 an error is thrown suggesting to use read_blob instead. See the read_text guide for more details. replace_type(value...Description | Parse a human-readable byte size string (e.g., '16 KiB' ) into a UBIGINT number of bytes. Throws an error on invalid input. | | Example | parse_formatted_bytes('1.5 GiB') | | Result | 1610612736 | pg_typeof(expression) | Description | Retu... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
DuckDB 2.0 Documentation / man.mtool.work