Results of 1 - 5 of about 5 for conjunction (0.002 sec.)
- Boolean Type 12777
- 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
...explicitly created using the literals true and false . However, 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 clause...ECT * FROM integers WHERE i > 10; In this case 5 and NULL are 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.,...AND false X AND NULL true true false NULL false false false false NULL NULL false NULL Below is the truth table for the OR conjunction (i.e., x OR y ). X X OR true X OR false X OR NULL true true true true false true false NULL NULL true NULL NULL Expression... - https://man.mtool.work/duckdb/2.0/sql/data_types/boolean.html
- COPY Statement 8843
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...represent a NULL value. VARCHAR (empty) PREFIX Prefixes the CSV file with a specified string. This option must be used in conjunction with SUFFIX and requires HEADER to be set to false . VARCHAR (empty) SUFFIX Appends a specified string as a suffix to the...CSV file. This option must be used in conjunction with PREFIX and requires HEADER to be set to false . VARCHAR (empty) QUOTE The quoting character to be used when a data va... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- AWS Extension 8346
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...y. If you would like to install and load it manually, run: INSTALL AND LOAD aws; In most cases, the aws extension works in conjunction with the httpfs extension . Configuration and Authentication Tip For an overview of the available methods and guidance on... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Unnesting 8346
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...ta structures, as it maintains the structure and naming convention of the original data. The parameter can also be used in conjunction with the max_depth parameter, allowing more control and enabling more precise management of nested structures.... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- Spatial Functions 7611
- 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
...y the geometry fragment. To construct a complete GeoJSON document or feature, look into using the DuckDB JSON extension in conjunction with this function. This function supports geometries with Z values, but not M values. M values are ignored. Example selec... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work