Results of 1 - 10 of about 14 for insensitive (0.004 sec.)
- Keywords and Identifiers – DuckDB 13741
- 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
...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 following two queries are equivalent: select COS ( Pi ()) as CosineOfPi ; SELECT cos ( pi ())...AS CosineOfPi ; CosineOfPi -1.0 Case-Sensitivity of Identifiers Identifiers in DuckDB are always case-insensitive, similarly to PostgreSQL. However, unlike PostgreSQL (and some other major SQL implementations), DuckDB also treats quoted...identifiers as case-insensitive. Comparison of identifiers: Case-insensitivity is implemented using an ASCII-based comparison: col_A and col_a are equal b... - https://man.mtool.work/duckdb/1.3/sql/dialect/keywords_and_identifiers.html
- PostgreSQL Compatibility – DuckDB 11955
- 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 = '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 lowercasing unquoted identifiers within SQL, whereas quoting preserv...entifiers would be lowercased all the time. Therefore, DuckDB achieves case insensitivity by making identifiers fully case insensitive throughout the system but preserving their case . In DuckDB, the scripts above complete successfully: CREATE TABLE MyTaBLe...false ; CREATE TABLE MyTaBLe ( x INTEGER ); SELECT table_name FROM duckdb_tables (); table_name mytable However, the case insensitive matching in the system for identifiers cannot be turned off. Using Double Equality Sign for Comparison DuckDB supports bot... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Pattern Matching – DuckDB 8945
- 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
...'%c' ; -- true SELECT 'abc' NOT LIKE '%c' ; -- false The keyword ILIKE can be used instead of LIKE to make the match case-insensitive according to the active locale: SELECT 'abc' ILIKE '%C' ; -- true SELECT 'abc' NOT ILIKE '%C' ; -- false To search within...l percent sign then 'c': SELECT 'a%c' LIKE 'a$%c' ESCAPE '$' ; -- true SELECT 'azc' LIKE 'a$%c' ESCAPE '$' ; -- false Case-insensitive ILIKE with ESCAPE: SELECT 'A%c' ILIKE 'a$%c' ESCAPE '$' ; -- true There are also alternative characters that can be used a... - https://man.mtool.work/duckdb/1.3/sql/functions/pattern_matching.html
- Text Functions – DuckDB 8752
- 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
...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_string) Returns...ike_specifier, escape_character) Returns false 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 . not_like_escape(string, like_specifie...er, escape_character) Description 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 . Example ilike_escape('A%c', 'a$%C', '... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- WHERE Clause – DuckDB 8349
- 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-sensitive LIKE expression: SELECT * FROM table_name WHERE name LIKE '%mark%' ; Select all rows that match the given case-insensitive expression formulated with the ILIKE operator: SELECT * FROM table_name WHERE name ILIKE '%mark%' ; Select all rows that m... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/where.html
- Window Functions – DuckDB 8139
- 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
...stinct elements; but it can be used together with any aggregate function in the system. There are some aggregates that are insensitive to duplicate values (e.g., min , max ) and for them this clause is parsed and ignored. -- Count the number of distinct use...erminate results (e.g., mode , list and string_agg ). These can be made deterministic by ordering the arguments. For order-insensitive aggregates, this clause is parsed and ignored. -- Compute the modal value up to each time, breaking ties in favour of the... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Data Types – DuckDB 7947
- 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
...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, see the Rules for Case Sensitivity section . Updating Values of Nested Types When performing updates on val... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Aggregate Functions – DuckDB 7947
- 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
...stinct elements; but it can be used together with any aggregate function in the system. There are some aggregates that are insensitive to duplicate values (e.g., min and max ) and for them this clause is parsed and ignored. ORDER BY Clause in Aggregate Func...lause ensures that the values being aggregated are sorted before applying the function. Most aggregate functions are order-insensitive, and for them this clause is parsed and discarded. However, there are some order-sensitive aggregates that can have non-de... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
- SELECT Clause – DuckDB 7947
- 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
...name ). If a name is not provided by the user the expressions are named automatically by the system. Column names are case-insensitive. See the Rules for Case Sensitivity for more details. Star Expressions Select all columns from the table called table_name... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- SELECT Statement – DuckDB 7947
- 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
...aggregates and window functions. The DISTINCT keyword ensures that only unique tuples are returned. Column names are case-insensitive. See the Rules for Case Sensitivity for more details. FROM Clause The FROM clause specifies the source of the data on whic... - https://man.mtool.work/duckdb/1.3/sql/statements/select.html
DuckDB 1.3 Documentation / man.mtool.work