Results of 1 - 10 of about 370 for Case (0.006 sec.)
- Keywords and Identifiers – DuckDB 12220
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...character, e.g., to create an identifier named IDENTIFIER "X" , use "IDENTIFIER ""X""" . Deduplicating Identifiers In some cases, duplicate identifiers can occur, e.g., column names may conflict when unnesting a nested data structure. In these cases,...to attach to a database that has one of these names, use an alias, e.g.: ATTACH 'temp.db' AS temp2 ; USE temp2 ; Rules for Case-Sensitivity Keywords and Function Names SQL keywords and function names are case-insensitive in DuckDB. For example, the f... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- Relational API – DuckDB 11171
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...all_varchar : Optional[bool] Treat all columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_padding : Optional[bool] Enable null padding for rows with missing columns. names : Optional[List[str]] List of colu...all_varchar : Optional[bool] Treat all columns as VARCHAR. normalize_names : Optional[bool] Normalize column names to lowercase. null_padding : Optional[bool] Enable null padding for rows with missing columns. names : Optional[List[str]] List of colu... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- PostgreSQL Compatibility – DuckDB 10819
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...1 error true '1.1' = 1.1 true true 1 = 1.1 false false true = 'true' true true true = 1 error true 'true' = 1 error error Case Sensitivity for Quoted Identifiers PostgreSQL is case-insensitive. The way PostgreSQL achieves case insensitivity is by lo...wercasing unquoted identifiers within SQL, whereas quoting preserves case, e.g., the following command creates a table named mytable but tries to query for MyTaBLe because quotes preserve the case... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- FILTER Clause – DuckDB 10757
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...ng a pivoted view of a dataset. FILTER provides a cleaner syntax for pivoting data when compared with the more traditional CASE WHEN approach discussed below. Some aggregate functions also do not filter out NULL values, so using a FILTER clause will...return valid results when at times the CASE WHEN approach will not. This occurs with the functions first and last , which are desirable in a non-aggregating pivot ope... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/filter.html
- CASE Expression – DuckDB 10334
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...rview Storage Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown CASE Expression The CASE expression performs a switch based on a condition. The basic form is identical to the ternary conditio...n 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... - https://man.mtool.work/duckdb/1.3/sql/expressions/case.html
- Expression API – DuckDB 8096
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...ect ( const ). show () ┌─────────┐ │ 'hello' │ │ varchar │ ├─────────┤ │ hello │ │ hello │ │ hello │ │ hello │ └─────────┘ Case Expression This expression contains a CASE WHEN (...) THEN (...) ELSE (...) END expression. By default ELSE is NULL and it...ition = ..., value = ...) . import duckdb import pandas as pd from duckdb import ( ConstantExpression , ColumnExpression , CaseExpression ) df = pd . DataFrame ({ 'a' : [ 1 , 2 , 3 , 4 ], 'b' : [ True , None , False , True ], 'c' : [ 42 , 21 , 13 , 1... - https://man.mtool.work/duckdb/1.3/clients/python/expression.html
- Text Functions – DuckDB 6837
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...xadecimal representation to a blob. greatest(arg1, ...) Returns the largest value in lexicographical order. Note that lowercase characters are considered larger than uppercase characters and collations are not supported. hash(value, ...) Returns a UB...ing, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern Matching ) using case-insensitive matching. escape_character is used to search for wildcard characters in the string . instr(string, search_stri... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Boolean Type – DuckDB 6132
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...oolean values can be used in the WHERE and HAVING clauses of a SQL statement to filter out tuples from the result. In this case, tuples for which the predicate evaluates to true will pass the filter, and tuples for which the predicate evaluates to fa...O integers VALUES ( 5 ), ( 15 ), ( NULL ); Select all entries where i > 10 : SELECT * FROM integers WHERE i > 10 ; In this case 5 and NULL are filtered out ( 5 > 10 is false and NULL > 10 is NULL ): i 15 Conjunctions The AND / OR conjunctions can be... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
- Data Types – DuckDB 6132
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...posite Types DuckDB supports five nested data types: ARRAY , LIST , MAP , STRUCT , and UNION . Each supports different use cases and has a different structure. Name Description Rules when used in a column Build from values Define in DDL/CREATE ARRAY.... Rows may be set to different member types of the union. union_value(num := 2) UNION(num INTEGER, text VARCHAR) Rules for Case Sensitivity The keys of MAP s are case-sensitive, while keys of UNION s and STRUCT s are case-insensitive. For examples, s... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- CSV Auto Detection – DuckDB 5999
- 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
...al List Literal Types Map NULL Values Numeric Struct Text Time Timestamp Time Zones Union Typecasting Expressions Overview CASE Expression Casting Collations Comparisons IN Operator Logical Operators Star Expression Subqueries TRY Functions Overview...em will try to auto-detect all options. However, options can be individually overridden by the user. This can be useful in case the system makes a mistake. For example, if the delimiter is chosen incorrectly, we can override it by calling the read_cs...empt to figure out the types of each of the columns. Note that this step is only performed if we are calling read_csv . In case of the COPY statement the types of the table that we are copying into will be used instead. The type detection works by at... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
DuckDB 1.3 Documentation / man.mtool.work