Results of 1 - 10 of about 11 for negative (0.004 sec.)
- Array Functions – DuckDB 13780
- 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
...he array elements can not be NULL . The arrays can have any size as long as the size is the same for both arguments. array_negative_inner_product(array1, array2) Compute the negative inner product between two arrays of the same size. The array elements c...uivalent to -array_inner_product . array_dot_product(array1, array2) Alias for array_inner_product(array1, array2) . array_negative_dot_product(array1, array2) Alias for array_negative_inner_product(array1, array2) . array_value(arg1, ...) Description Cr...roduct(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) Result 20.0 array_negative_inner_product(array1, array2) Description Compute the negative inner product between two arrays of the same size. The arra... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- List Functions – DuckDB 10064
- 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
...serve the original order. list_dot_product(list1, list2) Computes the dot product of two same-sized lists of numbers. list_negative_dot_product(list1, list2) Computes the negative dot product of two same-sized lists of numbers. Equivalent to - list_dot_p...in, end, step) list_slice with added step feature. list_slice(list, begin, end) Extract a sublist using slice conventions. Negative values are accepted. See slicing . list_sort(list) Sorts the elements of the list. See the Sorting Lists section for more...two same-sized lists of numbers. Example list_dot_product([1, 2, 3], [1, 2, 5]) Result 20.0 Alias list_inner_product list_negative_dot_product(list1, list2) Description Computes the negative dot product of two same-sized lists of numbers. Equivalent to... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Date Types – DuckDB 9691
- 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
...t epoch is simply a notational shorthand that will be converted to the date value when read. SELECT '-infinity' :: DATE AS negative , 'epoch' :: DATE AS epoch , 'infinity' :: DATE AS positive ; negative epoch positive -infinity 1970-01-01 infinity Functi...ons See Date Functions . 関連キーワード infinity epoch date dates Types Date Description year month calendar values system negative positive Functions Documentation Copy Markdown Aliases Calendar specifies combination DuckDB follows standard 関連するペー... - https://man.mtool.work/duckdb/1.3/sql/data_types/date.html
- Numeric Types – DuckDB 9442
- 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 error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 -...ery digit takes up an extra bit, rounded up to 8 (12 digits take 12 bits, rounded up to 16, becomes two extra bytes). Both negative and positive values are supported by the VARINT type. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also avail...s a range of around 1E-307 to 1E+308 with a precision of at least 15 digits. Positive numbers outside of these ranges (and negative numbers ourside the mirrored ranges) may cause errors on some platforms but will usually be converted to zero or infinity,... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Text Functions – DuckDB 8197
- 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
...ntions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respectively. Negative values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). str...a string using a (1-based) index . array_slice(list, begin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the...ntions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respectively. Negative values are accepted. Example 'DuckDB'[:4] Result Duck Alias array_slice string LIKE target Description Returns true if the... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Vector Similarity Search Extension – DuckDB 8072
- 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
...nction Description l2sq array_distance Euclidean distance cosine array_cosine_distance Cosine similarity distance ip array_negative_inner_product Negative inner product Note that while each HNSW index only applies to a single column you can create multip...diately reflected in the index, but are instead “marked” as deleted, which can cause the index to grow stale over time and negatively impact query quality and performance. To remedy the last point, you can call the PRAGMA hnsw_compact_index ( ' index_nam... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- Sharing Macros – DuckDB 7823
- 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
...hat allows creating shorthands for common tasks. Sharing a Scalar Macro First, we defined a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (without rounding) as follows: duckdb pretty_print_intege... - https://man.mtool.work/duckdb/1.3/guides/snippets/sharing_macros.html
- Schema – DuckDB 7717
- 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
...s UNIQUE , PRIMARY KEY , and FOREIGN KEY . These constraints can be beneficial for ensuring data integrity but they have a negative effect on load performance as they necessitate building indexes and performing checks. Moreover, they very rarely improve... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- CREATE SEQUENCE Statement – DuckDB 7717
- 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
...ch value is added to the current sequence value to create a new value. A positive value will make an ascending sequence, a negative one a descending sequence. The default value is 1. maxvalue The optional clause MAXVALUE maxvalue determines the maximum v... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
- Timestamp Types – DuckDB 7592
- 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
...orresponding timestamp value when read. SELECT '-infinity' :: TIMESTAMP , 'epoch' :: TIMESTAMP , 'infinity' :: TIMESTAMP ; Negative Epoch Positive -infinity 1970-01-01 00:00:00 infinity Functions See Timestamp Functions . Time Zones To understand time zo... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
DuckDB 1.3 Documentation / man.mtool.work