Results of 1 - 10 of about 12 for successfully (0.005 sec.)
- PostgreSQL Compatibility – DuckDB 13778
- 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
...tor: SELECT 1 // 2 AS x ; This returns 0 . UNION of Boolean and Integer Values The following query fails in PostgreSQL but successfully completes in DuckDB: SELECT true AS x UNION SELECT 2 ; PostgreSQL returns an error: ERROR: UNION types boolean and integer...rings to numeric and boolean values. Therefore, there are several instances, where PostgreSQL throws an error while DuckDB successfully computes the result: Expression PostgreSQL DuckDB '1.1' = 1 error true '1.1' = 1.1 true true 1 = 1.1 false false true = 't...identifiers fully case insensitive throughout the system but preserving their case . In DuckDB, the scripts above complete successfully: CREATE TABLE MyTaBLe ( x INTEGER ); SELECT * FROM "MyTaBLe" ; CREATE TABLE "PreservedCase" ( x INTEGER ); SELECT * FROM P... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Prepared Statements – DuckDB 10860
- 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
...rams Returns the number of parameters that can be provided to the given prepared statement. Returns 0 if the query was not successfully prepared. Syntax idx_t duckdb_nparams ( duckdb_prepared_statement prepared_statement ); Parameters prepared_statement : Th...parameter at the given index. Returns DUCKDB_TYPE_INVALID if the parameter index is out of range or the statement was not successfully prepared. Syntax duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); Paramet...type for the parameter at the given index. Returns nullptr if the parameter index is out of range or the statement was not successfully prepared. The return type of this call should be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logical_type d... - https://man.mtool.work/duckdb/1.3/clients/c/prepared.html
- ODBC 101: A Duck Themed Guide to ODBC – DuckDB 9975
- 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
...ror information. The following table defines the return codes : Return code Description SQL_SUCCESS The function completed successfully SQL_SUCCESS_WITH_INFO The function completed successfully, but additional information is available, including a warnin SQL...ing error, i.e., when a handle is not allocated before it is used, or is the wrong type SQL_NO_DATA The function completed successfully, but no more data is availabl SQL_NEED_DATA More data is needed, such as when a parameter data is sent at execution time,... - https://man.mtool.work/duckdb/1.3/guides/odbc/general.html
- Windows – DuckDB 8224
- 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
...MAKE_BUILD_TYPE = Release -DBUILD_EXTENSIONS = "icu;parquet;json" cmake --build . --config Release Once the build finishes successfully, you can find the duckdb.exe binary in the repository's directory: ./duckdb.exe Building the Go Client Building on Windows... - https://man.mtool.work/duckdb/1.3/dev/building/windows.html
- CLI Charting with YouPlot – DuckDB 8224
- 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
...YouPlot repository . If you're on a Mac, you can use: brew install youplot Run uplot --help to ensure you've installed it successfully! Piping DuckDB Queries to stdout By combining the COPY...TO function with a CSV output file, data can be read from any for... - https://man.mtool.work/duckdb/1.3/guides/data_viewers/youplot.html
- Casting – DuckDB 8224
- 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
.... For example, it is not possible to convert an INTEGER to a DATE . Casts may also throw errors when the cast could not be successfully performed. For example, trying to cast the string 'hello' to an INTEGER will result in an error being thrown. SELECT CAST... - https://man.mtool.work/duckdb/1.3/sql/expressions/cast.html
- Linux – DuckDB 7941
- 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
...ning pip : apk add g++ py3-pip python3-dev pip install duckdb Using the DuckDB CLI Client on Linux Once the build finishes successfully, you can find the duckdb binary in the build directory: build/release/duckdb For different build configurations ( debug ,... - https://man.mtool.work/duckdb/1.3/dev/building/linux.html
- macOS – DuckDB 7941
- 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
...and build DuckDB as follows. git clone https://github.com/duckdb/duckdb cd duckdb GEN = ninja make Once the build finishes successfully, you can find the duckdb binary in the build directory: build/release/duckdb For different build configurations ( debug ,... - https://man.mtool.work/duckdb/1.3/dev/building/macos.html
- Crashes – DuckDB 7941
- 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
...optimizer is causing the crash, try to turn it off and re-run the query: PRAGMA disable_optimizer ; If the query finishes successfully, then the crash was caused by one or more optimizer rules. To pinpoint the specific rules that caused the crash, you can t... - https://man.mtool.work/duckdb/1.3/guides/troubleshooting/crashes.html
- Complete API – DuckDB 7641
- 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
...rams Returns the number of parameters that can be provided to the given prepared statement. Returns 0 if the query was not successfully prepared. Syntax idx_t duckdb_nparams ( duckdb_prepared_statement prepared_statement ); Parameters prepared_statement : Th...parameter at the given index. Returns DUCKDB_TYPE_INVALID if the parameter index is out of range or the statement was not successfully prepared. Syntax duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); Paramet...type for the parameter at the given index. Returns nullptr if the parameter index is out of range or the statement was not successfully prepared. The return type of this call should be destroyed with duckdb_destroy_logical_type . Syntax duckdb_logical_type d... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
DuckDB 1.3 Documentation / man.mtool.work