Results of 1 - 10 of about 46 for special (0.006 sec.)
- SELECT Clause – DuckDB 12677
- 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
...a function on all given columns of a table: SELECT min ( COLUMNS ( * )) FROM addresses ; To select columns with spaces or special characters, use double quotes ( " ): SELECT "Some Column Name" FROM tbl ; Syntax SELECT List The SELECT clause contains a...hing the given regular expression from the table: SELECT COLUMNS ( 'number\d+' ) FROM addresses ; The star expression is a special expression that expands to multiple expressions based on the contents of the FROM clause. In the simplest case, * expands...s in the addresses table grouped by city: SELECT city , count ( * ) FROM addresses GROUP BY city ; Aggregate functions are special functions that combine multiple rows into a single value. When aggregate functions are present in the SELECT clause, the q... - https://man.mtool.work/duckdb/1.3/sql/query_syntax/select.html
- Python Function API – DuckDB 12250
- 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
...omatically 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 exception is thrown from the Python function, it will be re-thrown i...urns 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.typing import * def dont_intercept_null ( x ): return 5 duckdb . create_function ( "dont_inte...], BIGINT ) res = duckdb . sql ( "SELECT dont_intercept(NULL)" ). fetchall () print ( res ) [(None,)] With null_handling="special" : import duckdb from duckdb.typing import * def dont_intercept_null ( x ): return 5 duckdb . create_function ( "dont_inte... - https://man.mtool.work/duckdb/1.3/clients/python/function.html
- NULL Values – DuckDB 11182
- 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
...Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown NULL Values NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL valu...t have the NOT NULL qualifier: CREATE TABLE integers ( i INTEGER ); INSERT INTO integers VALUES ( NULL ); NULL values have special semantics in many parts of the query as well as in many functions: Any comparison with a NULL value returns NULL , includi...l ( NULL , 'default_string' ); default_string SELECT ifnull ( 1 , 'default_string' ); 1 NULL and AND / OR NULL values have special behavior when used with AND and OR . For details, see the Boolean Type documentation . NULL and IN / NOT IN The behavior o... - https://man.mtool.work/duckdb/1.3/sql/data_types/nulls.html
- Date Types – DuckDB 10114
- 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 keyword, where the data must be formatted according to the ISO 8601 format ( YYYY-MM-DD ). SELECT DATE '1992-09-20' ; Special Values There are also three special date values that can be used on input: Input string Description epoch 1970-01-01 (Unix...day zero) infinity Later than all other dates -infinity Earlier than all other dates The values infinity and -infinity are specially represented inside the system and will be displayed unchanged; but epoch is simply a notational shorthand that will be c...Report content issue © 2026 DuckDB Foundation, Amsterdam NL DuckDB Home Code of Conduct Trademark Use Blog In this article Special Values Functions... - https://man.mtool.work/duckdb/1.3/sql/data_types/date.html
- Text Types – DuckDB 9901
- 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
...expressions to a text type applying a string operator , or invoking a function that returns a text type value Strings with Special Characters To use special characters in string, use escape string literals or dollar-quoted string literals . Alternativel...t Trademark Use Blog In this article Specifying a Length Limit Specifying a Compression Type Text Type Values Strings with Special Characters Functions... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- JSON Overview – DuckDB 9474
- 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
...rrays (or other serializable values). While it is not a very efficient format for tabular data, it is very commonly used, especially as a data interchange format. JSONPath and JSON Pointer Syntax DuckDB implements multiple interfaces for JSON extraction...ily key's value with a JSONPath expression as a VARCHAR : SELECT j ->> '$.family' FROM example ; anatidae Using Quotes for Special Characters JSON object keys that contain the special [ and . characters can be used by surrounding them with double quotes...h and JSON Pointer Syntax Indexing Examples Loading JSON Writing JSON JSON Data Type Retrieving JSON Data Using Quotes for Special Characters... - https://man.mtool.work/duckdb/1.3/data/json/overview.html
- Timestamp Types – DuckDB 9474
- 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
...le. The UTC offsets of 'America/Denver' and 'Europe/Berlin' at all involved instants are -07:00 and +01:00 , respectively. Special Values Three special strings can be used to create timestamps: Input string Description epoch 1970-01-01 00:00:00[+00] (Un...infinity Later than all other timestamps -infinity Earlier than all other timestamps The values infinity and -infinity are special cased and are displayed unchanged, whereas the value epoch is simply a notational shorthand that is converted to the corre...nduct Trademark Use Blog In this article Timestamp Types Conversion between Strings and Naïve / Time Zone-Aware Timestamps Special Values Functions Time Zones Instants Temporal Binning Time Zone Support Calendar Support Settings... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Python DB API – DuckDB 8833
- 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
...used to provide a dict that contains key->value pairs referencing settings understood by DuckDB. In-Memory Connection The special value :memory: can be used to create an in-memory database . Note that for an in-memory database no data is persisted to d...isk (i.e., all data is lost when you exit the Python process). Named In-memory Connections The special value :memory: can also be postfixed with a name, for example: :memory:conn3 . When a name is provided, subsequent duckdb....method of DuckDBPyConnection is also available on the duckdb module, this connection is what's used by these methods. The special value :default: can be used to get this default connection. File-Based Connection If the database is a file path, a connec... - https://man.mtool.work/duckdb/1.3/clients/python/dbapi.html
- Numeric Types – DuckDB 8619
- 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
...converted to zero or infinity, respectively. In addition to ordinary numeric values, the floating-point types have several special values representing IEEE 754 special values: Infinity : infinity -Infinity : negative infinity NaN : not a number On machi...nes with the required CPU/FPU support, DuckDB follows the IEEE 754 specification regarding these special values, with two exceptions: NaN compares equal to NaN and greater than any other floating point number. Some floating poi... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- INSERT Statement – DuckDB 8406
- 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
...flicting row(s) instead. The SET expressions that follow determine how these rows are updated. The expressions can use the special virtual table EXCLUDED , which contains the conflicting values for the row. Optionally you can provide an additional WHERE...ignored instead. Because we need a way to refer to both the to-be-inserted tuple and the existing tuple, we introduce the special EXCLUDED qualifier. When the EXCLUDED qualifier is provided, the reference refers to the to-be-inserted tuple, otherwise,...it refers to the existing tuple. This special qualifier can be used within the WHERE clauses and SET expressions of the ON CONFLICT clause. CREATE TABLE tbl ( i INTEGER... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
DuckDB 1.3 Documentation / man.mtool.work