Results of 1 - 4 of about 4 for unquoted (0.001 sec.)
- JSON Type 11927
- DuckDB supports json via the JSON logical type. For example: SELECT '[1, null, {"key": "value"}]'::JSON; [1, null, {"key": "value"}] Logically, the JSON type is similar to a VARCHAR , but with the restriction that it must be valid JSON. Phy
...sically, the data is stored as a VARCHAR . For example, you can't parse invalid JSON: SELECT 'unquoted'::JSON; Conversion Error: Malformed JSON at byte 0 of input: unexpected character. Input: "unquoted" Instead, what you pro... - https://man.mtool.work/duckdb/2.0/data/json/json_type.html
- Reading Faulty CSV Files 9985
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...s than expected. In our example, any line with more than two columns would cause this error, e.g., Pedro,01-01-1992,pdet . UNQUOTED VALUE : Quoted values in CSV lines must always be unquoted at the end; if a quoted value remains quoted throughout, it wil...l cause an error. For example, assuming our scanner uses quote='"' , the line "pedro"holanda, 01-01-1992 would present an unquoted value error. LINE SIZE OVER MAXIMUM : DuckDB has a parameter that sets the maximum line size a CSV file can have, which by... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
- Keywords and Identifiers 7526
- 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
... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- PostgreSQL Compatibility 7526
- 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
...ty 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 table named mytable but trie... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work