Results of 1 - 10 of about 10 for correspond (0.004 sec.)
- ODBC Configuration – DuckDB 13211
- 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
...An example of odbc.ini with DuckDB: [DuckDB] Driver = DuckDB Driver Database = :memory: access_mode = read_only The lines correspond to the following parameters: [DuckDB] : between the brackets is a DSN for the DuckDB. Driver : Describes the driver's name...the DuckDB: [ODBC] Trace = yes TraceFile = /tmp/odbctrace [DuckDB Driver] Driver = /path/to/libduckdb_odbc.dylib The lines correspond to the following parameters: [ODBC] : The DM configuration section. Trace : Enables the ODBC trace file using the option y...Driver driver system configuration path specific mode section using directory contains drivers knobs Database access lines correspond following parameters between brackets Describes 関連するページ ODBC API on Linux ODBC API on Windows ODBC API on macOS ODB... - https://man.mtool.work/duckdb/1.3/clients/odbc/configuration.html
- Timestamp with Time Zone Functions – DuckDB 11119
- 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
...ing the struct variant of the date_part function. Name Description current_localtime() Returns a TIME whose GMT bin values correspond to local time in the current time zone. current_localtimestamp() Returns a TIMESTAMP whose GMT bin values correspond to lo...timestamp. Effectively, the result is a “local” time. current_localtime() Description Returns a TIME whose GMT bin values correspond to local time in the current time zone. Example current_localtime() Result 08:47:56.497 current_localtimestamp() Descripti...on Returns a TIMESTAMP whose GMT bin values correspond to local date and time in the current time zone. Example current_localtimestamp() Result 2022-12-17 08:47:56.497 localtime... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Interval Type – DuckDB 9725
- 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
...granular unit; e.g., INTERVAL '1.5 years' or INTERVAL 18 MONTHS . Three basis units are necessary because a month does not correspond to a fixed amount of days (February has fewer days than March) and a day doesn't correspond to a fixed amount of microseco...ween two TIMESTAMP s is not equivalent to computing the number of partition boundaries between the two TIMESTAMP s for the corresponding unit, as computed by the datediff function: SELECT datediff ( 'day' , TIMESTAMP '2020-01-01 01:00:00' , TIMESTAMP '2020... - https://man.mtool.work/duckdb/1.3/sql/data_types/interval.html
- List Functions – DuckDB 8330
- 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
...See the Lambda Functions page for more details. list_grade_up(list) Works like sort, but the results are the indexes that correspond to the position in the original list instead of the actual values. list_has_all(list, sub-list) Returns true if all elemen...[5, 6] Aliases array_filter , filter list_grade_up(list) Description Works like sort, but the results are the indexes that correspond to the position in the original list instead of the actual values. Example list_grade_up([30, 10, 40, 20]) Result [2, 4, 1... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Building Configuration – DuckDB 7991
- 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
...ding DuckDB Copy Markdown Building Configuration Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and co... - https://man.mtool.work/duckdb/1.3/dev/building/build_configuration.html
- Writing Tests – DuckDB 7991
- 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
...ctions for generating test data. test_all_types Function The test_all_types table function generates a table whose columns correspond to types ( BOOL , TINYINT , etc.). The table has three rows encoding the minimum value, the maximum value, and the NULL va... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/writing_tests.html
- SQL Quirks – DuckDB 7991
- 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
...es use a zero-based indexing . Types UINT8 vs. INT8 UINT8 and INT8 are aliases to integer types of different widths: UINT8 corresponds to UTINYINT because it's an 8-bit unsigned integer INT8 corresponds to BIGINT because it's an 8-byte signed integer Expla...ation: the n in the numeric type INTn and UINTn denote the width of the number in either bytes or bits. INT1 , INT2 , INT4 correspond to the number of bytes, while INT16 , INT32 and INT64 correpsond to the number of bits. The same applies to UINT values. H...owever, the value n = 8 is a valid choice for both the number of bits and bytes. For unsigned values, UINT8 corresponds to UTINYINT (8 bits). For signed values, INT8 corresponds to BIGINT (8 bytes). Expressions Results That May Surprise You... - https://man.mtool.work/duckdb/1.3/sql/dialect/sql_quirks.html
- Subqueries – DuckDB 7991
- 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
...ry in the SELECT clause (without referring to a specific column) turns each row of the subquery into a struct whose fields correspond to the columns of the subquery. For example: SELECT t FROM ( SELECT unnest ( generate_series ( 41 , 43 )) AS x , 'hello' A... - https://man.mtool.work/duckdb/1.3/sql/expressions/subqueries.html
- WITH Clause – DuckDB 7651
- 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
...: USING KEY This is a recursive CTE where USING KEY has a key column ( a ) and a payload column ( b ). The payload columns correspond to the columns to be overwritten. In the first iteration we have two different keys, 1 and 2 . These two keys will generat... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/with.html
- DuckDB_% Metadata Functions – DuckDB 7294
- 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
..., the list of parameter names. VARCHAR[] parameter_types If the function has parameters, a list of logical data type names corresponding to the parameter list. VARCHAR[] varargs The name of the data type in case the function has a variable number of argume...NT sql The definition of this object, expressed as SQL DDL-statement. VARCHAR Attributes like temporary , start_value etc. correspond to the various options available in the CREATE SEQUENCE statement and are documented there in full. Note that the attribut... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work