Results of 1 - 7 of about 7 for contrast (0.002 sec.)
- Map Type 11414
- MAP s are similar to STRUCT s in that they are an ordered list of key-value pairs. However, MAP s do not need to have the same keys present for each row, and thus are suitable for use cases where the schema is unknown beforehand or varies p
...MAP s may not have duplicate keys. MAP s return NULL if a key is not found rather than throwing an error as structs do. In contrast, STRUCT s must have string keys, but each value may have a different type. See the data types overview for a comparison be... - https://man.mtool.work/duckdb/2.0/sql/data_types/map.html
- UPDATE Statement 11414
- The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1,
...t deterministic results, ensure that each target row matches at most one source row, e.g., by deduplicating the source. In contrast, the sub-select form throws an error if the subquery returns more than one row (unless the scalar_subquery_error_on_multip... - https://man.mtool.work/duckdb/2.0/sql/statements/update.html
- Reading Multiple Files 10542
- DuckDB can read multiple files of different types (CSV, Parquet, JSON files) at the same time using either the glob syntax, or by providing a list of files to read. See the combining schemas page for tips on reading files with different sch
...'); This reads the same files as read_parquet('dir/**/*.parquet') . A trailing slash on the directory path is optional. In contrast, read_parquet('dir/*.parquet') reads only files directly inside dir . Files with other extensions are ignored by directory... - https://man.mtool.work/duckdb/2.0/data/multiple_files/overview.html
- Spatial Functions 7979
- 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
...T_Contains (geom1 GEOMETRY, geom2 GEOMETRY) Description Returns true if the first geometry contains the second geometry In contrast to ST_ContainsProperly , this function will also return true if geom2 is contained strictly on the boundary of geom1 . A g...eom1 GEOMETRY, geom2 GEOMETRY) Description Returns true if the first geometry \"properly\" contains the second geometry In contrast to ST_Contains , this function does not return true if geom2 is contained strictly on the boundary of geom1 . A geometry a... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- CREATE MACRO Statement 7979
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...be passed either positionally or by name. Positional parameter passing means that only the value expression is passed; In contrast to positional parameter passing, named parameter passing explicitly assigns the actual parameter value to a specific forma... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- Window Functions 7124
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...accept IGNORE NULLS respect nulls by default. This default behavior can optionally be made explicit via RESPECT NULLS . In contrast, all aggregate window functions (except for list and its aliases, which retain NULL values unless a FILTER condition exclu... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
- WITH Clause 7124
- The WITH clause allows you to specify common table expressions (CTEs). Regular (non-recursive) common-table-expressions are essentially views that are limited in scope to a particular query. CTEs can reference each other and can be nested.
...a regular recursive CTE appends result rows to the union table, which ultimately defines the overall result of the CTE. In contrast, a CTE with USING KEY has the ability to update rows that have been placed in the union table in an earlier iteration: if... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/with.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work