Results of 1 - 10 of about 75 for Boolean (0.003 sec.)
- Configuration 13601
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...D_ONLY or READ_WRITE ). VARCHAR automatic allocator_background_threads Whether to enable the allocator background threads. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocation larger than this occurs, flush outstanding alloca...ator after completing a task. VARCHAR 134217728B allow_asterisks_in_http_paths Allow '*' character in URLs users can query BOOLEAN false allow_community_extensions Allow loading extensions build by the community. BOOLEAN true allow_extension_repositorie...to 'forbidden'. VARCHAR undecided allow_extensions_metadata_mismatch Allow to load extensions with no compatible metadata. BOOLEAN false allow_parser_override_extension Allow extensions to override the current parser. VARCHAR DEFAULT allow_persistent_se... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Boolean Type 11822
- Name Aliases Description BOOLEAN BOOL Logical Boolean ( true / false ) The BOOLEAN type represents a statement of truth (“true” or “false”). In SQL, the BOOLEAN field can also have a third state “unknown” which is represented by the SQL NUL
...L value. Select the three possible values of a BOOLEAN column: SELECT true, false, NULL::BOOLEAN; Boolean values can be explicitly created using the literals true and false . Ho...r, they are most often created as a result of comparisons or conjunctions. For example, the comparison i > 10 results in a Boolean value. Boolean values can be used in the WHERE and HAVING clauses of a SQL statement to filter out tuples from the result....filtered out ( 5 > 10 is false and NULL > 10 is NULL ): i 15 Conjunctions The AND / OR conjunctions can be used to combine Boolean values. Below is the truth table for the AND conjunction (i.e., x AND y ). X X AND true X AND false X AND NULL true true f... - https://man.mtool.work/duckdb/2.0/sql/data_types/boolean.html
- ODBC Extension Functions 11044
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...f ODBC parameter placeholders ? equal to the source_columns_count Optional named parameters (create table): create_table ( BOOLEAN , default: FALSE ): whether to create a table in the destination remote DB using the column names and column types from th...(or string) to be used to quote column names in the generated CREATE TABLE and INSERT queries commit_after_create_table ( BOOLEAN , default: FALSE ): whether to issue a COMMIT after executing CREATE TABLE , enabled automatically for Firebird Optional n...amed parameters (query parameters handling): decimal_params_as_chars ( BOOLEAN , default: false ): pass DECIMAL parameters as VARCHAR s integral_params_as_decimals ( BOOLEAN , default: false ): pass (u... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Spatial Functions 10641
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...00... ST_AsMVTGeom Signatures GEOMETRY ST_AsMVTGeom (geom GEOMETRY, bounds BOX_2D, extent BIGINT, buffer BIGINT, clip_geom BOOLEAN) GEOMETRY ST_AsMVTGeom (geom GEOMETRY, bounds BOX_2D, extent BIGINT, buffer BIGINT) GEOMETRY ST_AsMVTGeom (geom GEOMETRY,...lip geometry to a tile boundary See ST_AsMVT for more details ST_AsSVG Signature VARCHAR ST_AsSVG (geom GEOMETRY, relative BOOLEAN, precision INTEGER) Description Convert the geometry into a SVG fragment or path The SVG fragment is returned as a string....The fragment is a path element that can be used in an SVG document. The second boolean argument specifies whether the path should be relative or absolute. The third argument specifies the maximum number of dig... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Iceberg Options 9516
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...CHAR vended_credentials Access delegation mode. Allowed values are vended_credentials and none . SUPPORT_NESTED_NAMESPACES BOOLEAN false Set to true for catalogs that support nested namespaces. STAGE_CREATE_TABLES BOOLEAN true Controls whether DuckDB us...es staged CREATE TABLE . Disable for catalogs that do not support staged table creation. DISABLE_MULTI_TABLE_COMMIT BOOLEAN false Disables the multi-table transactions/commit endpoint. Enable for catalogs that reject this endpoint. SKIP_CREATE_TA...BLE_METADATA_UPDATES BOOLEAN false Skips follow-up metadata updates after non-staged CREATE TABLE . Enable for catalogs that fully initialize metadata... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- DuckDB_% Metadata Functions 9516
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...mment created by the COMMENT ON statement . VARCHAR internal true if this column is built-in, false if it is user-defined. BOOLEAN column_default The default value of the column (expressed in SQL) VARCHAR is_nullable true if the column can hold NULL val...ues; false if the column cannot hold NULL -values. BOOLEAN is_generated true if the column is a generated column , false otherwise. Available as of DuckDB 2.0. BOOLEAN generation_ex...irs. MAP(VARCHAR, VARCHAR) internal true indicates a system or built-in database. false indicates a user-defined database. BOOLEAN type The type indicates the type of RDBMS implemented by the attached database. For DuckDB databases, that value is duckdb... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Excel Extension 8905
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...n use the read_xlsx function instead. The following named parameters are supported. Option Type Default Description header BOOLEAN automatically inferred Whether to treat the first row as containing the names of the resulting columns. sheet VARCHAR auto...matically inferred The name of the sheet in the xlsx file to read. Default is the first sheet. all_varchar BOOLEAN false Whether to read all cells as containing VARCHAR s. ignore_errors BOOLEAN false Whether to ignore errors and silently...ells between the first row of consecutive non-empty cells and the first empty row spanning the same columns. stop_at_empty BOOLEAN automatically inferred Whether to stop reading the file when an empty row is encountered. If an explicit range option is p... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- PostgreSQL Extension Functions 8085
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...d schema is going to be re-read on the next access. Parameters None. Returns A table with the following columns: Success ( BOOLEAN ): a flag whether the cache clearing was successful Currently the table result is always returned with zero rows, so the f...ait when acquiring a connection from a pool where all available connections are already taken. enable_thread_local_cache ( BOOLEAN ): whether to enable the connection caching in thread-local cache. Such connections are getting pinned to the threads and...is enabled ( enable_reaper_thread option), then this number is checked in background periodically. enable_reaper_thread ( BOOLEAN ): whether to enable the connection pool reaper thread, that periodically scans the pool to check the max_lifetime_millis... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Dutch Railway Datasets 8085
- Examples in this documentation often use datasets based on the Dutch Railway datasets . These high-quality datasets are maintained by the team behind the Rijden de Treinen (Are the trains running?) application . This page contains download
...ULL Service:Company VARCHAR YES NULL NULL NULL Service:Train number BIGINT YES NULL NULL NULL Service:Completely cancelled BOOLEAN YES NULL NULL NULL Service:Partly cancelled BOOLEAN YES NULL NULL NULL Service:Maximum delay BIGINT YES NULL NULL NULL Sto...rival time TIMESTAMP WITH TIME ZONE YES NULL NULL NULL Stop:Arrival delay BIGINT YES NULL NULL NULL Stop:Arrival cancelled BOOLEAN YES NULL NULL NULL Stop:Departure time TIMESTAMP WITH TIME ZONE YES NULL NULL NULL Stop:Departure delay BIGINT YES NULL NU...LL NULL Stop:Departure cancelled BOOLEAN YES NULL NULL NULL Datasets 80-Month Datasets 2019-01 to 2025-08 : 80 months as uncompressed CSVs in a single zip Yearly D... - https://man.mtool.work/duckdb/2.0/guides/snippets/dutch_railway_datasets.html
- SQL to/from JSON 7988
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...return the resulting rows. Only one statement at a time is supported for now. json_serialize_plan(varchar, skip_default := boolean, format := boolean, optimize := boolean) Scalar Serialize the bound logical query plan of a set of semicolon-separated ( ;...) statements to JSON. If optimize is true , the optimized plan is serialized. json_serialize_sql(varchar, skip_default := boolean, skip_empty := boolean, skip_null := boolean, format := boolean) Scalar Serialize a set of semicolon-separated ( ; ) selec... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
DuckDB 2.0 Documentation / man.mtool.work