Results of 1 - 10 of about 68 for Optional (0.006 sec.)
- Regular Expressions 13459
- DuckDB offers pattern matching operators ( LIKE , SIMILAR TO , GLOB ), as well as support for regular expressions via functions. Regular Expression Syntax DuckDB uses the RE2 library as its regular expression engine. For the regular express
...ion syntax, see the RE2 docs . Functions All functions accept an optional set of options . Name Description regexp_extract(string, pattern[, group = 0][, options]) If string contains the regexp pa...ttern , returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaul...ts to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the regexp pattern , returns... - https://man.mtool.work/duckdb/2.0/sql/functions/regular_expressions.html
- Text Functions 11743
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
..._extract(string, regex[, group][, options]) If string contains the regex pattern, returns the capturing group specified by optional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaul...ts to 0. A set of optional regex options can be set. regexp_extract(string, regex, name_list[, options]) If string contains the regex pattern, return...corresponding names from name_list ; otherwise, returns a struct with the same keys and empty strings as values. A set of optional regex options can be set. regexp_extract_all(string, regex[, group][, options]) Finds non-overlapping occurrences of the r... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- ODBC Extension Functions 11091
- 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) ->
...bc_connect('Driver={Oracle Driver};DBQ=//127.0.0.1:1521/XE', 'scott', 'tiger') odbc_copy odbc_copy(conn_handle BIGINT, [, <optional named parameters>]) -> TABLE odbc_copy(conn_string VARCHAR, [, <optional named parameters>]) -> TABLE Copies rows from a D...-off queries, in this case new ODBC connection will be opened and will be closed automatically after the query is complete Optional named parameters (source): Source query is executed using a separate DB instance from the instance on which odbc_copy is b...ding LIMIT <limit> OFFSET <offset> to it, must be more or equal to 2048 , 2048 must be dividable by it without a remainder Optional named parameters (destination): dest_table ( VARCHAR ): destination table name in remote DB, will be used in INSERT and CR... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Utility Functions 10878
- Scalar Utility Functions The functions below are difficult to categorize into specific function types and are broadly useful. Name Description alias(column) Return the name of the column. can_cast_implicitly(source_value, target_value) Whet
...mplicitly cast from the types of the source value to the target value. checkpoint(database) Synchronize WAL with file for (optional) database without interrupting transactions. coalesce(expr, ...) Return the first expression that evaluates to a non- NULL...config]) Formats the sql string, e.g., by placing each clause on a separate line and normalizing the case of keywords. The optional config is a MAP(VARCHAR, VARCHAR) with the keys 'indent_size' , 'inline_threshold' and 'keyword_case' ( 'upper' , 'lower'...may be adjusted to produce more aesthetically pleasing results. force_checkpoint(database) Synchronize WAL with file for (optional) database interrupting transactions. gen_random_uuid() Return a random UUID similar to this: eeccb8c5-9943-b2bb-bb5e-222f4... - https://man.mtool.work/duckdb/2.0/sql/functions/utility.html
- PostgreSQL Extension Functions 9814
- 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
...he flag value is not available. Example CALL postgres_clear_cache() postgres_configure_pool FROM postgres_configure_pool([⟨optional named parameters⟩]) -> TABLE When a PostgreSQL database is attached, a connection pool is created for this database. This...uire_mode = 'wait', max_connections = 42) postgres_execute postgres_execute(attached_db_name VARCHAR, sql_query VARCHAR[, ⟨optional named parameters⟩]) -> TABLE Executes the ⟨sql_query⟩ in the specified remote Postgres instance previously attached with A...AR ): query that is passed to PostgreSQL for execution; no transformation or analysis of this query is performed by DuckDB Optional named parameters: use_transaction ( BOOLEAN , default: TRUE ): whether to start a PostgreSQL transaction if it was not sta... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- CREATE SEQUENCE Statement 9162
- The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate
...Value New This feature was introduced in DuckDB 2.0. Use setval to set a sequence to a given value (PostgreSQL-style). The optional third argument is_called defaults to true : the next nextval returns value + increment . If is_called is false , the next...created, you use the function nextval to operate on the sequence. Parameters Name Description CYCLE or NO CYCLE The CYCLE option allows the sequence to wrap around when the maxvalue or minvalue has been reached by an ascending or descending sequence res...ts maximum value will return an error. If neither CYCLE nor NO CYCLE are specified, NO CYCLE is the default. increment The optional clause INCREMENT BY increment specifies which value is added to the current sequence value to create a new value. A positi... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- PREPARE, EXECUTE, and DEALLOCATE Statements 8850
- The PREPARE statement creates a prepared statement for later execution. The EXECUTE statement runs it with optional arguments. The DEALLOCATE statement removes it. For details about auto-incremented, positional, and named parameters, see Pr
...itional arguments: EXECUTE add_values(20, 22); Syntax DEALLOCATE Remove a prepared statement: DEALLOCATE query_person; The optional PREPARE keyword is accepted for PostgreSQL compatibility: DEALLOCATE PREPARE add_values; Syntax... - https://man.mtool.work/duckdb/2.0/sql/statements/prepare.html
- Python Function API 8410
- You can create a DuckDB user-defined function (UDF) from a Python function so it can be used in SQL queries. Similarly to regular functions , they need to have a name, a return type and parameter types. Creating Functions To register a Pyth
.... return_type Scalar functions return one element per row. This parameter specifies the return type of the function. type (optional): DuckDB supports both native Python types and PyArrow Arrays. By default, type = 'native' is assumed, but you can specify..., using an Arrow UDF will be much more efficient than native because it will be able to operate in batches. null_handling (optional): By default, NULL values are automatically handled as NULL -in NULL -out. Users can specify a desired behavior for NULL v...alues by setting null_handling = 'special' . exception_handling (optional): By default, when an exception is thrown from the Python function, the query fails with an error that names it. Users can... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- EXPLAIN ANALYZE: Profile Queries 7885
- Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan, and executes it, providing run-time performance numbers and the actual cardinality (number of rows produced) for every operator. EXPLAIN ANALYZE SELECT * FROM tbl; N
...│ Type: Sequential Scan │ │ Projections: sid │ │ Projections: sid, name │ │ Dynamic Filters: │ │ Filters: name >= 'Ma' │ │ optional: (sid IN (1, 3)) AND optional: sid IN PRF(sid) │ │ Row Groups Scanned: 1 / 1 │ │ Row Groups Scanned: 1 / 1 │ │ 2 rows 0µs... - https://man.mtool.work/duckdb/2.0/guides/meta/explain_analyze.html
- Lambda Functions 7885
- 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
...mn is retained, and discarded otherwise. COLUMNS -clause lambdas have a mandatory parameter that receives the column name. Optionally, a second parameter may be declared that receives the (1-based) column index. The syntax for a lambda expression is: lam...ed by the list function to pass the current element of the list. This is typically the first parameter. There is always an optional parameter used by the list function to pass the (1-based) index of the current element. This is always the last parameter....le scalar value by executing the lambda function on a running result and the next list element. The lambda function has an optional initial_value argument. See list_reduce examples . list_transform(list, lambda(x)) Returns a list that is the result of ap... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
DuckDB 2.0 Documentation / man.mtool.work