Results of 1 - 10 of about 59 for passed (0.002 sec.)
- ODBC Extension Functions 13772
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...with odbc_create_params params ( STRUCT ): parameters values Returns: Parameters handle ( BIGINT ), the same one that was passed as a second argument. Example: SELECT odbc_bind_params(getvariable('conn'), getvariable('params1'), row(42, 'foo')) odbc_c..., they are appended to the connection string as UID and PWD . Parameters: conn_string ( VARCHAR ): ODBC connection string, passed to the Driver Manager. Returns: Connection handle that can be placed into a VARIABLE . Connection is not closed automatica...itted every time after the specified number of rows is processed close_connection ( BOOLEAN , default: false ): closes the passed connection after the function call is completed, intended to be used with one-shot invocations of the odbc_copy Returns: A... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- GROUPING SETS 11204
- GROUPING SETS , ROLLUP and CUBE can be used in the GROUP BY clause to perform a grouping over multiple dimensions within the same query. Note that this syntax is not compatible with GROUP BY ALL . Examples Compute the average income along t
...g set, you can think of GROUPING_ID(y, q, m) writing to a bitfield, where the first bit corresponds to the last expression passed to GROUPING_ID() , the second bit to the one-but-last expression passed to GROUPING_ID() , and so on. This may become clea...4 11 0 000 2023 4 12 0 000 2023 4 NULL 1 001 2023 NULL NULL 3 011 NULL NULL NULL 7 111 Note that the number of expressions passed to GROUPING_ID() , or the order in which they are passed is independent from the actual group definitions appearing in the...GROUPING SETS -clause (or the groups implied by ROLLUP and CUBE ). As long as the expressions passed to GROUPING_ID() are expressions that appear somewhere in the GROUPING SETS -clause, GROUPING_ID() will set a bit correspo... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/grouping_sets.html
- Unnesting 10810
- Unnesting is an operation that decomposes values of a composite types into its components. Values of the LIST and STRUCT type may be unnested using the unnest() function . Unnesting turns a LIST -typed value into a table column: each list-e
...n only be unnested using the unnest() function. Calling unnest() The LIST or STRUCT value that is to be unnested is always passed as the first – mandatory – argument to the unnest() function. The unnest() function has a number of optional additional ar...sting By default, unnest() only unpacks the outermost components of the composite-type value. Additional parameters may be passed to allow the unnesting operation to be applied to the unnested member values, and to their unnested values, and so on, rec...rsion should at most be applied. Values greater than 1 imply recursion, and in such cases recursive need not be explicitly passed as true . keep_parent_names : BOOLEAN , default: false . Whether to create column names using the keys of all ancestor mem... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/unnest.html
- CREATE MACRO Statement 10810
- The CREATE MACRO statement defines a named, callable SQL expression as a database schema object. Macros may declare parameters, which can be referenced by its expression. Once a macro is created, it may be called by referencing its name and
...ectively makes the parameter optional: when the macro is called, the DuckDb binder will find candidate signatures based on passed parameters, but backfilled by signatures that specify default values for missing parameters. A parameter that specifies a...find an implementation of the macro that has a matching signature. If an implementation is found, the parameter values are passed and the implementation's expression is evaluated; finally, its resulting value is returned and used in place where the mac...o can appear in the FROM clause of a SELECT statement, or in a CALL statement . Passing Parameters Parameter values can be passed to the macro as a comma-separated list of expressions appearing between the parentheses following the macro's name. Parame... - https://man.mtool.work/duckdb/2.0/sql/statements/create_macro.html
- ODBC API on macOS 9818
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
...driver supports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed to SQLDriverConnect and in the odbc.ini file, the one passed to SQLDriverConnect will take precedence. For the details of... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Connect 8826
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...pertyInfo() call, which returns one DriverPropertyInfo per DuckDB setting alongside the driver's own options. Note Options passed at connection time are applied as global settings on the database instance. A setting that only has session scope has to b...e driver splits the URL on ; and each entry on = , so a value that itself contains a semicolon or an equals sign has to be passed in a Properties object instead. Option Precedence When the same option appears in both places, the value in the URL wins:...rameworks and BI tools that add JDBC properties of their own. The driver already discards two options that are known to be passed by mistake: Apache Spark's path and LibreOffice Base's Type . JDBC-Specific Options Alongside DuckDB's own settings, the d... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- ODBC API on Windows 8826
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...driver supports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed to SQLDriverConnect and in the odbc.ini file, the one passed to SQLDriverConnect will take precedence. For the details of... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- PostgreSQL Extension Functions 8622
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...Parameters attached_db_name ( VARCHAR ): the name of the attached PostgreSQL database sql_query ( VARCHAR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters:...Parameters attached_db_name ( VARCHAR ): the name of the attached PostgreSQL database sql_query ( VARCHAR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters:...UE ): whether to start a PostgreSQL transaction if it was not started before. params ( STRUCT ): query parameters that are passed to the PostgreSQL server; only supported when the text protocol is used Returns A table with the query result. Example FRO... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Lambda Functions 8622
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...referenced in the ⟨expression⟩ . The number of allowed and required parameters depends on the list function to which it is passed. There is always a mandatory parameter that is used by the list function to pass the current element of the list. This is... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Connect 8228
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...ows until Next() returns false connector, _ := duckdb.NewConnector("", nil) defer connector.Close() // if the connector is passed to sql.OpenDB Failing to close a persistent database can leave changes in the write-ahead log that are not synchronized to...and connections opened here to send queries and read results. Configuration — the full list of DuckDB settings that can be passed in the DSN or the connector callback. Concurrency — how DuckDB handles multiple connections and threads. Troubleshoot — cg... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
DuckDB 2.0 Documentation / man.mtool.work