Results of 1 - 10 of about 28 for equal (0.004 sec.)
- Comparisons – DuckDB 13944
- 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
...comparison is NULL . Operator Description Example Result < less than 2 < 3 true > greater than 2 > 3 false <= less than or equal to 2 <= 3 true >= greater than or equal to 4 >= NULL NULL = or == equal NULL = NULL NULL <> or != not equal 2 <> 2 false T...he table below shows the standard distinction operators. These operators treat NULL values as equal. Operator Description Example Result IS DISTINCT FROM not equal, including NULL 2 IS DISTINCT FROM NULL true IS NOT DISTIN...CT FROM equal, including NULL NULL IS NOT DISTINCT FROM NULL true Combination Casting When performing comparison on different types, Duc... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Keywords and Identifiers – DuckDB 11339
- 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
...nsitive. Comparison of identifiers: Case-insensitivity is implemented using an ASCII-based comparison: col_A and col_a are equal but col_á is not equal to them. SELECT col_A FROM ( SELECT 'x' AS col_a ); -- succeeds SELECT col_ á FROM ( SELECT 'x' AS...n Nested Data Structures The keys of MAP s are case-sensitive: SELECT MAP ([ 'key1' ], [ 1 ]) = MAP ([ 'KEY1' ], [ 1 ]) AS equal ; false The keys of UNION s and STRUCT s are case-insensitive: SELECT { 'key1' : 1 } = { 'KEY1' : 1 } AS equal ; true SELE...CT union_value ( key1 : = 1 ) = union_value ( KEY1 : = 1 ) as equal ; true Handling Conflicts In case of a conflict, when the same identifier is spelt with different cases, one will be selec... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Samples – DuckDB 10913
- 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
...d. reservoir Reservoir sampling is a stream sampling technique that selects a random sample by keeping a reservoir of size equal to the sample size, and randomly replacing elements as more elements come in. Reservoir sampling allows us to specify exac...ampling percentage is specified. It is rather straightforward: every row in the underlying table is included with a chance equal to the specified percentage. As a result, bernoulli sampling can return a different number of tuples even if the same perc...entage is specified. The expected number of rows is equal to the specified percentage of the table, but there will be some variance . Because bernoulli sampling is completely indep... - https://man.mtool.work/duckdb/1.3/sql/samples.html
- Caveats – DuckDB 10470
- 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
...ersions and Format Execution Format Pivot Sitemap Live Demo Documentation / Data Import / JSON Files Copy Markdown Caveats Equality Comparison Warning Currently, equality comparison of JSON files can differ based on the context. In some cases, it is b...rison. The following query returns true for all fields: SELECT a != b , -- Space is part of physical JSON content. Despite equal logical content, values are treated as not equal. c != d , -- Same. c [ 0 ] = d [ 0 ], -- Equality because space was remov...ed from physical content of fields: a = c [ 0 ], -- Indeed, field is equal to empty list without space... b != c [ 0 ], -- ... but different from empty list with space. FROM ( SELECT '[]' :: JSON A... - https://man.mtool.work/duckdb/1.3/data/json/caveats.html
- Text Functions – DuckDB 9897
- 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
...the first character of the string . bar(x, min, max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Converts a blob to a base64 encoded string. bin(stri...le ascii('Ω') Result 937 bar(x, min, max[, width]) Description Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. Example bar(5, 0, 20, 10) Result ██▌ base64(blob) Description Con...1, s2) The Hamming distance between to strings, i.e., the number of positions with different characters for two strings of equal length. Strings must be of equal length. Characters of different cases (e.g., a and A ) are considered different. jaccard(... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- inet Extension – DuckDB 8586
- 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
...68.1.0/24 127.0.0.1 127.0.0.1 2001:db8:3c4d:15::1a2f:1a2b/96 2001:db8:3c4d:15::/96 <<= Predicate Is subnet contained by or equal to subnet? CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '192.168.1.0/24' ), ( '127.0.0.1' ), ( '2001:db8:3c4d:...ET) «= cidr) 192.168.1.5/24 true 127.0.0.1 false 2001:db8:3c4d:15::1a2f:1a2b/96 false >>= Predicate Does subnet contain or equal subnet? CREATE TABLE tbl ( cidr INET ); INSERT INTO tbl VALUES ( '192.168.1.0/24' ), ( '127.0.0.1' ), ( '2001:db8:3c4d:15:...──────┘ 関連キーワード cidr ffff network inet subnet host netmask address broadcast extension addresses Computes Predicate equal escape varchar unescape Documentation Core Extensions Copy Markdown Extension defines type 関連するページ Environment Data... - https://man.mtool.work/duckdb/1.3/core_extensions/inet.html
- Subqueries – DuckDB 8586
- 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
...ALL , ANY and SOME In the section on scalar subqueries , a scalar expression was compared directly to a subquery using the equality comparison operator ( = ). Such direct comparisons only make sense with scalar subqueries. Scalar expressions can still...uate to true : SELECT 6 <= ALL ( SELECT grade FROM grades ) AS adequate ; returns: adequate true because 6 is less than or equal to each of the subquery results 7, 8 and 9. However, the following query SELECT 8 >= ALL ( SELECT grade FROM grades ) AS e...xcellent ; returns excellent false because 8 is not greater than or equal to the subquery result 7. And thus, because not all comparisons evaluate true , >= ALL as a whole evaluates to false . ANY... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- Utility Functions – DuckDB 8586
- 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
...s(min, max, bincount, nice := false) Returns the upper boundaries of a partition of the interval [min, max] into bin_count equal-sized subintervals (for use with, e.g., histogram ). If nice = true , then min , max , and bincount may be adjusted to pro...Returns true when arg is the "catch-all element" of its datatype for the purpose of the histogram_exact function, which is equal to the "right-most boundary" of its datatype for the purpose of the histogram function. md5(string) Returns the MD5 hash o...bincount, nice := false) Description Returns the upper boundaries of a partition of the interval [min, max] into bin_count equal-sized subintervals (for use with, e.g., histogram ). If nice = true , then min , max , and bincount may be adjusted to pro... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- Installing Extensions – DuckDB 7865
- 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
...rectory: ~/ .duckdb / extensions / duckdb_version / platform_name / For stable DuckDB releases, the duckdb_version will be equal to the version tag of that release. For nightly DuckDB builds, it will be equal to the short git hash of the build. So for... - https://man.mtool.work/duckdb/1.3/extensions/installing_extensions.html
- Interval Type – DuckDB 7865
- 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
...t then extracts the aforementioned six parts from period , adds them back together, and confirms that the result is always equal to the original period . SELECT period = list_reduce ( [ INTERVAL ( datepart ( part , period ) || part ) FOR part IN [ 'ye..., TIMESTAMP '2000-01-01 01:33:30' - INTERVAL '1 month 13 hours' , TIME '02:00:00' - INTERVAL '3 days 23 hours' , -- wraps; equals TIME '03:00:00' ; Adding an INTERVAL to a DATE returns a TIMESTAMP even when the INTERVAL has no microseconds component....020-01-02 00:00:00' ), -- 1 datepart ( 'day' , TIMESTAMP '2020-01-02 00:00:00' - TIMESTAMP '2020-01-01 01:00:00' ), -- 0 ; Equality and Comparison For equality and ordering comparisons only, the total number of microseconds in an INTERVAL is computed... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
DuckDB 1.3 Documentation / man.mtool.work