Results of 1 - 10 of about 11 for unchanged (0.002 sec.)
- JSON Processing Functions 12411
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...orig, patch) equals json_modified . Deleted keys appear as null , changed and added keys appear with their new values, and unchanged keys are omitted. Nested objects are diffed recursively. json_normalize(json) Return json in a canonical form by recursive...ry object, including objects nested inside arrays. The order of array elements is preserved and scalar values are returned unchanged. json_strip_nulls(json) Recursively remove all keys whose value is JSON null , including in objects nested inside arrays....null array elements are kept and scalar values are returned unchanged. Compute the patch between two documents: SELECT json_merge_patch_diff('{"a": 1, "b": 2, "c": 3}', '{"a": 1, "b": 99, "d":... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- ICU Extension 11131
- The icu extension provides collation, time zone, and calendar support. New In DuckDB 2.0, the dependency on the external ICU library was removed. The icu extension now implements collations, time zones, and calendars natively, with time zon
...e data built directly from the IANA Time Zone Database . Behavior is unchanged, and the native implementation is smaller and faster. If you ship a custom build, note that ICU is no longer bundled. Inst... - https://man.mtool.work/duckdb/2.0/core_extensions/icu.html
- Date Types 10491
- Name Aliases Description DATE Calendar date (year, month, day) A date specifies a combination of year, month and day. DuckDB follows the SQL standard's lead by counting dates exclusively in the Gregorian calendar, even for years before that
...r than all other dates The values infinity and -infinity are specially represented inside the system and will be displayed unchanged; but epoch is simply a notational shorthand that will be converted to the date value when read. SELECT '-infinity'::DATE A... - https://man.mtool.work/duckdb/2.0/sql/data_types/date.html
- Security 9531
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...d token. Authorization is permissive. The default authorization callback, quack_nop_authorization , returns the query text unchanged for every query. No further filtering happens. Both callbacks can be replaced with user-supplied code, including plain SQL...the returned string is then executed instead of the client's query (the default quack_nop_authorization returns the query unchanged). Anything resolvable as a function with the matching arity will work: built-in scalar functions, scalar UDFs registered b... - https://man.mtool.work/duckdb/2.0/quack/security.html
- GROUP BY Clause 9531
- The GROUP BY clause specifies which grouping columns should be used to perform any aggregations in the SELECT clause. If the GROUP BY clause is specified, the query is always an aggregate query, even if no aggregations are present in the SE
...lumns (i.e., all tuples that belong to the same group) will be combined. The values of the grouping columns themselves are unchanged, and any other columns can be combined using an aggregate function (such as count , sum , avg , etc). GROUP BY ALL Use GRO... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/groupby.html
- Timestamp Types 7912
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...mestamps -infinity Earlier than all other timestamps The values infinity and -infinity are special cased and are displayed unchanged, whereas the value epoch is simply a notational shorthand that is converted to the corresponding timestamp value when read... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- INSERT Statement 7912
- The INSERT statement inserts new data into a table. Examples Insert the values 1, 2, 3 into tbl : INSERT INTO tbl VALUES (1), (2), (3); Insert the result of a query into a table: INSERT INTO tbl SELECT * FROM other_tbl; Insert values into t
...d with a WHERE clause, which is checked for each conflicting row. Conflicting rows that do not meet the condition are left unchanged. This WHERE clause is part of the DO UPDATE SET action and must appear after it, as shown below. INSERT INTO tbl VALUES (1... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
- Delta Extension 7592
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...ther process committed a different version for my_app_id first, COMMIT fails. A rolled-back transaction leaves the version unchanged. Read the current version with delta_get_transaction_version(⟨table⟩, ⟨app_id⟩) , which returns NULL if no version has bee... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Iceberg Options 7592
- 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
...xplicit WITH ('location' = …) clause still takes precedence, and if the namespace has no location property the behavior is unchanged. Useful for catalogs such as AWS Glue that do not assign a table location server-side. Note: this feature was introduced i... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Text Functions 6952
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...d. Characters that are distinct letters in their own right rather than accented variants, such as ø , ł , and ß , are left unchanged (e.g., strip_accents('großmøller') returns großmøller ). | | Example | strip_accents('mühleisen') | | Result | muhleisen |... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
DuckDB 2.0 Documentation / man.mtool.work