Results of 1 - 10 of about 59 for equivalent (0.003 sec.)
- Time Functions – DuckDB 11715
- 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
...e_diff(part, starttime, endtime) The number of partition boundaries between the times. date_part(part, time) Get subfield (equivalent to extract ). date_sub(part, starttime, endtime) The number of complete partitions between the times. datediff(part, start...f date_diff . The number of partition boundaries between the times. datepart(part, time) Alias of date_part. Get subfield (equivalent to extract ). datesub(part, starttime, endtime) Alias of date_sub. The number of complete partitions between the times. ex...imes. Example date_diff('hour', TIME '01:02:03', TIME '06:01:03') Result 5 date_part(part, time) Description Get subfield (equivalent to extract ). Example date_part('minute', TIME '14:21:13') Result 21 date_sub(part, starttime, endtime) Description The nu... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
- Array Functions – DuckDB 11073
- 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
...array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. This is equivalent to 1.0 - array_cosine_similarity . array_distance(array1, array2) Compute the distance between two arrays of the same size...array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. This is equivalent to -array_inner_product . array_dot_product(array1, array2) Alias for array_inner_product(array1, array2) . array_negative...array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. This is equivalent to 1.0 - array_cosine_similarity . Example array_cosine_distance(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_va... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- CASE Expression – DuckDB 10854
- 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
...basic form is identical to the ternary condition used in many programming languages ( CASE WHEN cond THEN a ELSE b END is equivalent to cond ? a : b ). With a single condition this can be expressed with IF(cond, a, b) . CREATE OR REPLACE TABLE integers AS...est ([ 1 , 2 , 3 ]) AS i ; SELECT i , CASE WHEN i > 2 THEN 1 ELSE 0 END AS test FROM integers ; i test 1 0 2 0 3 1 This is equivalent to: SELECT i , IF ( i > 2 , 1 , 0 ) AS test FROM integers ; The WHEN cond THEN expr part of the CASE expression can be cha...; SELECT i , CASE i WHEN 1 THEN 10 WHEN 2 THEN 20 WHEN 3 THEN 30 END AS test FROM integers ; i test 1 10 2 20 3 30 This is equivalent to: SELECT i , CASE WHEN i = 1 THEN 10 WHEN i = 2 THEN 20 WHEN i = 3 THEN 30 END AS test FROM integers ; 関連キーワード in... - https://man.mtool.work/duckdb/1.3/sql/expressions/case.html
- Comparisons – DuckDB 10854
- 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
...special syntax mandated by the SQL standard. They are shown in the table below. Note that BETWEEN and NOT BETWEEN are only equivalent to the examples below in the cases where both a , x and y are of the same type, as BETWEEN will cast all of its inputs to...the same type. Predicate Description a BETWEEN x AND y equivalent to x <= a AND a <= y a NOT BETWEEN x AND y equivalent to x > a OR a > y expression IS NULL true if expression is NULL , fa...always be false . 関連キーワード operators equal expression standard comparison below type table Description These DuckDB equivalent shows Operator Example less greater including Combination Casting casts PostgreSQL stricter checking otherwise 関連するペー... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Interval Type – DuckDB 9585
- 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
...e constructed by providing amounts together with units. Units that aren't months , days , or microseconds are converted to equivalent amounts in the next smaller of these three basis units. SELECT INTERVAL 1 YEAR , -- single unit using YEAR keyword; stored...used with unit keywords (unless the unit is SECONDS or MILLISECONDS ). SELECT INTERVAL '1.5' YEARS ; -- Returns 12 months; equivalent to `to_years(CAST(trunc(1.5) AS INTEGER))` For more precision, include the unit in the string or use a more granular unit;...the given dates as integer value. Warning Extracting a component of the INTERVAL difference between two TIMESTAMP s is not equivalent to computing the number of partition boundaries between the two TIMESTAMP s for the corresponding unit, as computed by the... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- Pattern Matching – DuckDB 9585
- 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
...atches the supplied pattern. (As expected, the NOT LIKE expression returns false if LIKE returns true , and vice versa. An equivalent expression is NOT (string LIKE pattern) .) If pattern does not contain percent signs or underscores, then the pattern only...*' ; -- true SELECT 'abc' SIMILAR TO '(b|c).*' ; -- false SELECT 'abc' NOT SIMILAR TO 'abc' ; -- false In PostgreSQL, ~ is equivalent to SIMILAR TO and !~ is equivalent to NOT SIMILAR TO . In DuckDB, these equivalences do not hold currently, see the Postgr...gular Expressions page . DuckDB supports some PostgreSQL-style operators for regular expression matching: PostgreSQL-style Equivalent expression ~ regexp_full_match !~ NOT regexp_full_match ~* (not supported) !~* (not supported) 関連キーワード pattern expr... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- FROM and JOIN Clauses – DuckDB 9585
- 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
..., and it just returns all the possible pairs. Return all pairs of rows: SELECT a . * , b . * FROM a CROSS JOIN b ; This is equivalent to omitting the JOIN clause: SELECT a . * , b . * FROM a , b ; Conditional Joins Most joins are specified by a predicate t...ELECT * FROM city_airport SEMI JOIN airport_names USING ( iata ); city_name iata Amsterdam AMS Rotterdam RTM This query is equivalent with: SELECT * FROM city_airport WHERE iata IN ( SELECT iata FROM airport_names ); Anti Join Example Return a list of city...ELECT * FROM city_airport ANTI JOIN airport_names USING ( iata ); city_name iata Eindhoven EIN Groningen GRQ This query is equivalent with: SELECT * FROM city_airport WHERE iata NOT IN ( SELECT iata FROM airport_names WHERE iata IS NOT NULL ); Lateral Join... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/from.html
- List Type – DuckDB 9162
- 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
...th lists, DuckDB uses the ARRAY type . Creating Lists Lists can be created using the list_value(expr, ...) function or the equivalent bracket notation [expr, ...] . The expressions can be constants or arbitrary expressions. To create a list from a table co...rom a list can be accomplished using brackets and slicing notation, or through list functions like list_extract . Multiple equivalent functions are provided as aliases for compatibility with systems that refer to lists as arrays. For example, the function...SQL functions comparison Lists expressions table These return queries arrays DuckDB uses provided compatibility types expr equivalent 関連するページ Array Type SQL Quirks List Tables Map Type Pivot Internals INSERT Statement See this page as Markdown Edit... - https://man.mtool.work/duckdb/1.3/sql/data_types/list.html
- Date Functions – DuckDB 9162
- 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
...ff(part, startdate, enddate) The number of partition boundaries between the dates. date_part(part, date) Get the subfield (equivalent to extract ). date_sub(part, startdate, enddate) The number of complete partitions between the dates. date_trunc(part, dat...enddate) The number of partition boundaries between the dates. Alias of date_diff . datepart(part, date) Get the subfield (equivalent to extract ). Alias of date_part . datesub(part, startdate, enddate) The number of complete partitions between the dates....mple date_diff('month', DATE '1992-09-15', DATE '1992-11-14') Result 2 date_part(part, date) Description Get the subfield (equivalent to extract ). Example date_part('year', DATE '1992-09-20') Result 1992 date_sub(part, startdate, enddate) Description The... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- SQL to/from JSON – DuckDB 8520
- 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
...Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json serialized statements back to an equivalent SQL string. json_execute_serialized_sql(varchar) Table Execute json serialized statements and return the resulting rows. O...lean, skip_null := boolean, format := boolean) Scalar Serialize a set of semicolon-separated ( ; ) select statements to an equivalent list of json serialized statements. PRAGMA json_execute_serialized_sql(varchar) Pragma Pragma version of the json_execute_...deserialize_sql(json_serialize_sql(...)) may not be identical to the original statement, but should always be semantically equivalent and produce the same output. Examples Simple example: SELECT json_serialize_sql ( 'SELECT 2' ); {"error":false,"statements... - https://man.mtool.work/duckdb/1.3/data/json/sql_to_and_from_json.html
DuckDB 1.3 Documentation / man.mtool.work