Results of 1 - 10 of about 16 for desired (0.002 sec.)
- Python Function API 14001
- 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
...es. null_handling (optional): By default, NULL values are automatically handled as NULL -in NULL -out. Users can specify a desired behavior for NULL values by setting null_handling = 'special' . exception_handling (optional): By default, when an excepti...when functions receive a NULL value, this instantly returns NULL , as part of the default NULL -handling. When this is not desired, you need to explicitly set this parameter to "special" . import duckdb from duckdb.sqltypes import BIGINT def dont_interc...range(10)").fetchall() print(res) [(0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,)] Which is obviously not the desired result, when we add side_effects=True , the result is as we would expect: con.remove_function("my_counter") count.counter... - https://man.mtool.work/duckdb/2.0/clients/python/function.html
- Casting 10327
- Casting refers to the operation of converting a value in a particular data type to the corresponding value in another data type. Casting can occur either implicitly or explicitly. The syntax described here performs an explicit cast. More in
...t needs to return the same type in all code paths. We can perform the addition on any input column by adding a cast to the desired type – but we need to cast the result of the addition back to the source type to make the binding work.... - https://man.mtool.work/duckdb/2.0/sql/expressions/cast.html
- Dot Commands 9807
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...s to the terminal's standard output. However, this can be modified using either the .output or .once commands. Pass in the desired output file location as a parameter. The .once command will only output the next set of results and then revert to standar...supports SQL syntax to export data as CSV or Parquet , but the CLI-specific commands may be used to write a CSV instead if desired. .mode csv .once my_output_file.csv SELECT 1 AS col_1, 2 AS col_2 UNION ALL SELECT 10 AS col1, 20 AS col_2; The file my_ou... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- JSON Processing Functions 9270
- JSON Extraction Functions There are two extraction functions, which have their respective operators. The operators can only be used if the string is stored as the JSON logical type. These functions support the same two location notations as
...are produced as VARCHAR . To recover the original types, replace the relevant "VARCHAR" entries in the structure with the desired type name, for example "DATE" . SELECT json_contains('{"key": "value"}', '"value"'); true SELECT json_contains('{"key": 1}...SON of the same form as returned by json_structure . The structure argument can be modified to transform the JSON into the desired structure and types. It is possible to extract fewer key/value pairs than are present in the JSON, and it is also possible... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
- SQL Quirks 9270
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...Due to case-insensitivity, it's not possible to use SELECT a FROM 'file.parquet' when a column called A appears before the desired column a in file.parquet . USING SAMPLE The USING SAMPLE clause is syntactically placed after the WHERE and GROUP BY claus... - https://man.mtool.work/duckdb/2.0/sql/dialect/sql_quirks.html
- Full-Text Search Extension 8750
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...be used. Defaults to 'porter' stopwords VARCHAR Qualified name of table containing a single VARCHAR column containing the desired stopwords, or 'none' if no stopwords are to be used. Defaults to 'english' for a pre-defined list of 571 English stopwords... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Pattern Matching 8750
- There are four separate approaches to pattern matching provided by DuckDB: the traditional SQL LIKE operator , the more recent SIMILAR TO operator (added in SQL:1999), a GLOB operator , and POSIX-style regular expressions . LIKE The LIKE ex
...matches any sequence of zero or more characters. LIKE pattern matching always covers the entire string. Therefore, if it's desired to match a sequence anywhere within a string, the pattern must start and end with a percent sign. Some examples: SELECT 'a... - https://man.mtool.work/duckdb/2.0/sql/functions/pattern_matching.html
- Struct Functions 8750
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...s that have no source counterpart from defaults . Only the type of target_type is used, not its value, so any value of the desired type works; a typed NULL literal (e.g. NULL::STRUCT(v1 INT, v2 INT) ) is a convenient way to declare the target shape when... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- MySQL Extension 8231
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...e MySQL database, and the result of subsequent operations can then be read using MySQL. Note that if modifications are not desired, ATTACH can be run with the READ_ONLY property which prevents making modifications to the underlying database. For example... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Query 7711
- The duckdb_query method allows SQL queries to be run in DuckDB from C. This method takes two parameters, a (null-terminated) SQL query string and a duckdb_result result pointer. The result pointer may be NULL if the application is not inter
...fore be very fast. The duckdb_value functions perform bounds- and type-checking, and will automatically cast values to the desired type. This makes them more convenient and easier to use, at the expense of being slower. See the Types page for more infor... - https://man.mtool.work/duckdb/2.0/clients/c/query.html
DuckDB 2.0 Documentation / man.mtool.work