Results of 1 - 10 of about 370 for operators (0.003 sec.)
- Comparisons – DuckDB 13022
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Comparisons Comparison Operators The table below shows the standard comparison operators. Whenever either of the input arguments is NULL , the output of th...>= NULL NULL = or == equal NULL = NULL NULL <> or != not equal 2 <> 2 false The table below shows the standard distinction operators. These operators treat NULL values as equal. Operator Description Example Result IS DISTINCT FROM not equal, including NUL... - https://man.mtool.work/duckdb/1.3/sql/expressions/comparison_operators.html
- Logical Operators – DuckDB 11550
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...orage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Logical Operators The following logical operators are available: AND , OR and NOT . SQL uses a three-valuad logic system with true , false a...nd NULL . Note that logical operators involving NULL do not always evaluate to NULL . For example, NULL AND false will evaluate to false , and NULL OR true will... - https://man.mtool.work/duckdb/1.3/sql/expressions/logical_operators.html
- Tuning Workloads – DuckDB 10211
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...be changed using the temp_directory configuration option , e.g.: SET temp_directory = '/path/to/temp_dir.tmp/' ; Blocking Operators Some operators cannot output a single row until the last row of their input has been seen. These are called blocking opera...tors as they require their entire input to be buffered, and are the most memory-intensive operators in relational database systems. The main blocking operators are the following: grouping: GROUP BY joining: JOIN sorting: O... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- Expressions – DuckDB 8132
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...ot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown Expressions An expression is a combination of values, operators and functions. Expressions are highly composable, and range from very simple to arbitrarily complex. They can be found in...many different parts of SQL statements. In this section, we provide the different types of operators and functions that can be used within expressions. Pages in This Section 関連キーワード Expressions operators functions di... - https://man.mtool.work/duckdb/1.3/sql/expressions/overview.html
- Relational API on Pandas – DuckDB 7647
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...be used to chain together query operations. These are lazily evaluated so that DuckDB can optimize their execution. These operators can act on Pandas DataFrames, DuckDB tables or views (which can point to any underlying storage format that DuckDB can rea...ree" , "four" ]}) # create a DuckDB relation from a dataframe rel = con . from_df ( input_df ) # chain together relational operators (this is a lazy operation, so the operations are not yet executed) # equivalent to: SELECT i, j, i*2 AS two_i FROM input_d... - https://man.mtool.work/duckdb/1.3/guides/python/relational_api_pandas.html
- Boolean Type – DuckDB 7647
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...). X X OR true X OR false X OR NULL true true true true false true false NULL NULL true NULL NULL Expressions See Logical Operators and Comparison Operators . 関連キーワード Boolean values truth tuples table integers Logical statement created conjunction...s example used filter case predicate evaluates filtered Below conjunction Operators Documentation Types Copy Markdown Type 関連するページ NULL Values Logical Operators Loops CASE Expression INSERT Statement... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
- Numeric Functions – DuckDB 7647
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...nd Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Numeric Functions Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addit...shift left 1 << 4 16 >> Bitwise shift right 8 >> 2 2 ~ Bitwise negation ~15 -16 ! Factorial of x 4! 24 Division and Modulo Operators There are two division operators: / and // . They are equivalent when at least one of the operands is a FLOAT or a DOUBLE... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Profiling – DuckDB 7154
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...ormance characteristics of the query. However, it is often also necessary to examine the performance numbers of individual operators and the cardinalities that pass through them. The EXPLAIN ANALYZE statement enables obtaining these, as it pretty-prints t...top-level node, and the metrics it contains are measured over the entire query. The OPERATOR nodes refer to the individual operators in the query plan. Some metrics are only available for QUERY_ROOT nodes, while others are only for OPERATOR nodes. The tab... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- PostgreSQL Compatibility – DuckDB 7154
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...rtant. To work around this, add the other attributes or use the GROUP BY ALL clause . Behavior of Regular Expression Match Operators PostgreSQL supports the POSIX regular expression matching operators ~ (case-sensitive partial regex matching) and ~* (case...nd !~* , respectively. In DuckDB, ~ is equivalent to regexp_full_match and !~ is equivalent to NOT regexp_full_match . The operators ~* and !~* are not supported. The table below shows that the correspondence between these functions in PostgreSQL and Duck... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Time Functions – DuckDB 7154
- 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
...stamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview Aggregate Functions Array Functions Bitstring Functions Blob Functions D...Pivot Sitemap Live Demo Documentation / SQL / Functions Copy Markdown Time Functions This section describes functions and operators for examining and manipulating TIME values . Time Operators The table below shows the available mathematical operators for...t content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Time Operators Time Functions... - https://man.mtool.work/duckdb/1.3/sql/functions/time.html
DuckDB 1.3 Documentation / man.mtool.work