Results of 1 - 10 of about 370 for switch (0.003 sec.)
- CASE Expression – DuckDB 13621
- 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
...mat Pivot Sitemap Live Demo Documentation / SQL / Expressions Copy Markdown CASE Expression The CASE expression performs a switch based on a condition. The basic form is identical to the ternary condition used in many programming languages ( CASE WHEN...l expression after the CASE but before the WHEN . When this is done, the CASE expression is effectively transformed into a switch statement. CREATE OR REPLACE TABLE integers AS SELECT unnest ([ 1 , 2 , 3 ]) AS i ; SELECT i , CASE i WHEN 1 THEN 10 WHEN...THEN 20 WHEN i = 3 THEN 30 END AS test FROM integers ; 関連キーワード integers expression cond unnest condition equivalent switch single conditions clause Documentation Expressions Copy Markdown Expression performs based form identical ternary used man... - https://man.mtool.work/duckdb/1.3/sql/expressions/case.html
- Installing Extensions – DuckDB 9057
- 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 this installation with the spatial extension from the core_nightly repository: FORCE INSTALL spatial FROM core_nightly ; Switching between Repositories To switch repositories for an extension, use the FORCE INSTALL command. For example, if you have i...nstalled httpfs from the core_nightly repository but would like to switch back to using core , run: FORCE INSTALL httpfs FROM core ; Installing Extensions through Client APIs For many clients, usi...nstalling Extensions from Different Repositories Working with Multiple Repositories Force Installing to Upgrade Extensions Switching between Repositories Installing Extensions through Client APIs Installation Location Uninstalling Extensions Sharing Ex... - https://man.mtool.work/duckdb/1.3/extensions/installing_extensions.html
- SQLite Import – DuckDB 8140
- 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
...t ( TYPE sqlite ); -- The table "tbl_name" can now be queried as if it is a regular table SELECT * FROM test.tbl_name ; -- Switch the active database to "test" USE test ; -- List all tables in the file SHOW TABLES ; For more information see the SQLite... - https://man.mtool.work/duckdb/1.3/guides/database_integration/sqlite.html
- Logical Operators – DuckDB 8140
- 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
...ULL Unary Operator: NOT a NOT a true false false true NULL NULL The operators AND and OR are commutative, that is, you can switch the left and right operand without affecting the result. 関連キーワード operators evaluate Operators logical Documentation... - https://man.mtool.work/duckdb/1.3/sql/expressions/logical_operators.html
- PostgreSQL Import – DuckDB 7691
- 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
...( TYPE postgres ); -- The table "tbl_name" can now be queried as if it is a regular table SELECT * FROM test.tbl_name ; -- Switch the active database to "test" USE test ; -- List all tables in the file SHOW TABLES ; For more information see the Postgre... - https://man.mtool.work/duckdb/1.3/guides/database_integration/postgres.html
- Hive Partitioning – DuckDB 7233
- 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
...: DATE , 'orders' : BIGINT } ); hive_types will be auto-detected for the following types: DATE , TIMESTAMP and BIGINT . To switch off the auto-detection, the flag hive_types_autocast = 0 can be set. Writing Partitioned Files See the Partitioned Writes... - https://man.mtool.work/duckdb/1.3/data/partitioning/hive_partitioning.html
- SQLite Extension – DuckDB 6317
- 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
...2 ROLLBACK ; SELECT * FROM sqlite_db.tmp ; i Deprecated The old sqlite_attach function is deprecated. It is recommended to switch over to the new ATTACH syntax . 関連キーワード SQLite sqlite database DuckDB type film read tables category column declare... - https://man.mtool.work/duckdb/1.3/core_extensions/sqlite.html
- PostgreSQL Extension – DuckDB 5867
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...e internal caches. CALL pg_clear_cache (); Deprecated The old postgres_attach function is deprecated. It is recommended to switch over to the new ATTACH syntax. 関連キーワード postgres PostgreSQL database DuckDB using tables dbname query read connectio... - https://man.mtool.work/duckdb/1.3/core_extensions/postgres.html
- Versioning of Extensions – DuckDB 5867
- 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
...DuckDB In most cases, user's will be interested in a nightly build of a specific extension, but don't necessarily want to switch to using the nightly build of DuckDB itself. This allows using a specific bleeding-edge feature while limiting the exposur... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- Python – DuckDB 5409
- 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
...separated skip list SKIP_EXTENSIONS=parquet;jemalloc Flags DISABLE_PARQUET=1 , DISABLE_CORE_FUNCTIONS=1 , … “No built-ins” switch Throws out *every* statically linked extension except core_functions . Use CORE_EXTENSIONS=… to whitelist a subset back in... - https://man.mtool.work/duckdb/1.3/dev/building/python.html
DuckDB 1.3 Documentation / man.mtool.work