Results of 1 - 10 of about 370 for Boolean (0.005 sec.)
- Configuration – DuckDB 15171
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...EAD_ONLY or READ_WRITE ) VARCHAR automatic allocator_background_threads Whether to enable the allocator background thread. BOOLEAN false allocator_bulk_deallocation_flush_threshold If a bulk deallocation larger than this occurs, flush outstanding alloca...e allocator after completing a task. VARCHAR 128.0 MiB allow_community_extensions Allow to load community built extensions BOOLEAN true allow_extensions_metadata_mismatch Allow to load extensions with not compatible metadata BOOLEAN false allow_persiste... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Spatial Functions – DuckDB 11145
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...); ---- 01030000000100000005000000000000000000000000000 ... 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 strin...g. 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/1.3/core_extensions/spatial/functions.html
- Boolean Type – DuckDB 10828
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...erview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Boolean Type Name Aliases Description BOOLEAN BOOL Logical Boolean ( true / false ) The BOOLEAN type represents a statement of tru...th (“true” or “false”). In SQL, the BOOLEAN field can also have a third state “unknown” which is represented by the SQL NULL value. Select the three possible values o... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
- DuckDB_% Metadata Functions – DuckDB 9374
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...comment created by the COMMENT ON statement . VARCHAR internal true if this column 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 data_type The name of the column datatype. VARCHAR data_type_id The internal identifier of the column data type. BIGINT ch... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- Excel Extension – DuckDB 7850
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...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... - https://man.mtool.work/duckdb/1.3/core_extensions/excel.html
- Conversion between DuckDB and Python – DuckDB 6722
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...Conversion: Python Object to DuckDB This is a mapping of Python object types to DuckDB Logical Types : None → NULL bool → BOOLEAN datetime.timedelta → INTERVAL str → VARCHAR bytearray → BLOB memoryview → BLOB decimal.Decimal → DECIMAL / DOUBLE uuid.UUI...─┐ │ {'1': 'one', '2': 2, 'three': [1, 2, 3], 'False': true} │ │ struct("1" varchar, "2" integer, three integer[], "false" boolean) │ ├────────────────────────────────────────────────────────────────────┤ │ {'1': one, '2': 2, 'three': [1, 2, 3], 'False'... - https://man.mtool.work/duckdb/1.3/clients/python/conversion.html
- Dutch Railway Datasets – DuckDB 6396
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...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... - https://man.mtool.work/duckdb/1.3/guides/snippets/dutch_railway_datasets.html
- Types API – DuckDB 6237
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...ython Built-Ins The table below shows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR Numpy DTypes The table below shows the mapping of Numpy DTyp...e to DuckDB type. Type DuckDB type bool BOOLEAN float32 FLOAT float64 DOUBLE int16 SMALLINT int32 INTEGER int64 BIGINT int8 TINYINT uint16 USMALLINT uint32 UINTEGER uint6... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- SQL to/from JSON – DuckDB 6237
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...return the resulting rows. Only one statement at a time is supported for now. json_serialize_sql(varchar, skip_default := boolean, skip_empty := boolean, skip_null := boolean, format := boolean) Scalar Serialize a set of semicolon-separated ( ; ) selec...query location serialized statements serialize skip execute table deserialize varchar list Example node aggregate handling boolean empty children order bys operator column names 関連するページ Spark API JSON Import Profiling Queries INSERT Statements Py... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
- Full-Text Search Extension – DuckDB 5753
- 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
...LE Unnesting WITH WINDOW QUALIFY VALUES FILTER Set Operations Prepared Statements Data Types Overview Array Bitstring Blob Boolean Date Enum Interval List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expr...ns to be ignored. Defaults to '(\\.|[^a-z])+' , ignoring all escaped and non-alphabetic lowercase characters strip_accents BOOLEAN Whether to remove accents (e.g., convert á to a ). Defaults to 1 lower BOOLEAN Whether to convert all text to lowercase. D...efaults to 1 overwrite BOOLEAN Whether to overwrite an existing index on a table. Defaults to 0 This PRAGMA builds the index under a newly created schema... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
DuckDB 1.3 Documentation / man.mtool.work