Results of 1 - 7 of about 7 for near (0.001 sec.)
- ALTER DATABASE Statement 12486
- Warning The ALTER DATABASE statement is not supported in DuckDB 2.0.0: ALTER DATABASE ⟨old_name⟩ RENAME TO ⟨new_name⟩ fails with Parser Error: syntax error at or near "RENAME" . To rename an attached database, DETACH it and ATTACH it again
... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- SQL to/from JSON 10832
- DuckDB provides functions to serialize and deserialize SELECT statements between SQL and JSON, as well as executing JSON serialized statements. Function Type Description json_deserialize_sql(json) Scalar Deserialize one or many json seriali
...ELECT json_serialize_sql('TOTALLY NOT VALID SQL'); {"error":true,"error_type":"parser","error_message":"syntax error at or near \"VALID\"","location":"[12,5]","position":"12","error_subtype":"SYNTAX_ERROR"} Example with deserialize: SELECT json_deser..._serialized_sql(json_serialize_sql('TOTALLY NOT VALID SQL')); Parser Error: Error parsing json: parser: syntax error at or near "VALID" Serializing the bound logical plan of a statement with json_serialize_plan : SELECT json_serialize_plan('SELECT 1... - https://man.mtool.work/duckdb/2.0/data/json/sql_to_and_from_json.html
- Functions 9160
- Function Syntax Function Chaining via the Dot Operator DuckDB supports the dot syntax for function chaining. This allows the function call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...) . For example, take the followi
...rentheses (e.g., SELECT 2.sqrt(); ), DuckDB returns a Parser Error for the function call: Parser Error: syntax error at or near "(" Limitations Function chaining via the dot operator is limited to scalar functions and is not supported for table funct... - https://man.mtool.work/duckdb/2.0/sql/functions/overview.html
- ORDER BY Clause 8597
- ORDER BY is an output modifier. Logically it is applied near the very end of the query (just prior to LIMIT or OFFSET , if present). The ORDER BY clause sorts the rows on the sorting criteria in either ascending or descending order. In addi
... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/orderby.html
- DuckDB Wasm Client 8051
- Installation To use the DuckDB Wasm client, visit the duckdb-wasm GitHub repository . The latest stable version of the DuckDB WebAssembly client is 2.0.0. DuckDB-Wasm is a version of DuckDB that has been compiled to WebAssembly , the portab
...le binary format that browsers can run at near-native speed. This lets a full DuckDB engine run entirely inside any browser on any device, with no server to send queries... - https://man.mtool.work/duckdb/2.0/clients/wasm/overview.html
- Literal Types 7488
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...teral Concatenation Consecutive single-quoted string literals separated only by whitespace that contains at least one newline are implicitly concatenated: SELECT 'Hello' ' ' 'World' AS greeting; is equivalent to: SELECT 'Hello' || ' ' || 'World' AS g...pace without a newline results in a syntax error: SELECT 'Hello' ' ' 'World' AS greeting; Parser Error: syntax error at or near "' '" LINE 1: SELECT 'Hello' ' ' 'World' AS greeting; ^ Also note that implicit concatenation only works with single-quote...ones. Bit String and Hex String Literals New Starting with DuckDB 2.0, bit string and hex string literals are supported. In earlier versions, B'0101' and X'CAFE' were parsed as the VARCHAR strings 'b0101' and 'xCAFE' , respectively. A string literal... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Timestamp Types 6943
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...g., Parquet timestamp columns with isAdjustedToUTC=true , are now read as TIMESTAMPTZ_NS and retain their full precision. In earlier versions these columns were converted to TIMESTAMP WITH TIME ZONE and lost precision. SELECT TIMESTAMP_NS '1992-09-20...ns are ignored. Starting with DuckDB 2.0, time zone names in strings passed to a WITHOUT TIME ZONE type are also ignored (in earlier versions, names other than UTC raised an error). Finally, when WITH TIME ZONE and WITHOUT TIME ZONE types are convert...e-specific rules and can vary widely. For example, here is what binning for the 'America/Los_Angeles' time zone looks like near the epoch: The most common temporal binning problem occurs when daylight saving time changes. The example below contains a... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work