Results of 1 - 4 of about 4 for insensitivity (0.001 sec.)
- PostgreSQL Compatibility 11576
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...' = 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 preserves case, e.g., the following command creates a t...E "PreservedCase" (x INTEGER); SELECT * FROM PreservedCase; ERROR: relation "preservedcase" does not exist Therefore, case-insensitivity in PostgreSQL only works if you never use quoted identifiers with different cases. For DuckDB, this behavior was problemat...at are case-sensitive by default – since all identifiers 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 abov... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- SQL Quirks 10540
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...st occurrence shadowing the others: CREATE TABLE tbl AS SELECT 1 AS a; SELECT a FROM (SELECT *, 2 AS a FROM tbl); a 1 Case Insensitivity for SELECT ing Columns Due to case-insensitivity, it's not possible to use SELECT a FROM 'file.parquet' when a column call... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Friendly SQL 7415
- DuckDB offers several advanced SQL features and syntactic sugar to make SQL queries more concise. We refer to these colloquially as “friendly SQL”. Several of these features were first introduced by DuckDB, while some are inspired by other
...art of common table expressions SWITCH statements as syntactic sugar for the CASE expression Literals and Identifiers Case-insensitivity while maintaining case of entities in the catalog Deduplicating identifiers Underscores as digit separators in numeric lit... - https://man.mtool.work/duckdb/2.0/sql/dialect/friendly_sql.html
- Keywords and Identifiers 7415
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...her 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 but col_á is not equal to them. SELECT col_A FRO... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work