Results of 1 - 10 of about 21 for Defaults (0.008 sec.)
- Full-Text Search Extension – DuckDB 14139
- 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
...'romanian' , 'russian' , 'serbian' , 'spanish' , 'swedish' , 'tamil' , 'turkish' , or 'none' if no stemming is to 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 ignore VARCHAR Regular expression of patterns to be ignored....l escaped and non-alphabetic lowercase characters strip_accents BOOLEAN Whether to remove accents (e.g., convert á to a ). Defaults to 1 lower BOOLEAN Whether to convert all text to lowercase. Defaults to 1 overwrite BOOLEAN Whether to overwrite an exist... - https://man.mtool.work/duckdb/1.3/core_extensions/full_text_search.html
- Text Functions – DuckDB 12448
- 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
..., max[, width]) Draws a band whose width is proportional to ( x - min ) and equal to width characters when x = max . width defaults to 80. base64(blob) Converts a blob to a base64 encoded string. bin(string) Converts the string to binary representation....ltrim(string[, characters]) Removes any occurrences of any of the characters from the left side of the string . characters defaults to space . md5(string) Returns the MD5 hash of the string as a VARCHAR . md5_number(string) Returns the MD5 hash of the st...the path similarly to Python's os.path.basename function. If trim_extension is true , the file extension will be removed (defaults to false ). separator options: system , both_slash (default), forward_slash , backslash . parse_path(path[, separator]) Re... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Window Functions – DuckDB 9167
- 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 be of the Same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . last_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the row that is t...t be of the Same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . nth_value(expr, nth[ ORDER BY ordering][ IGNORE NULLS]) Returns expr evaluated at the nth row (...t be of the Same type as expr ). Both offset and default are evaluated with respect to the current row. If omitted, offset defaults to 1 and default to NULL . If an ORDER BY clause is specified, the lagged row number is computed within the frame using th... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- CREATE SEQUENCE Statement – DuckDB 9167
- 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
...value for the sequence. If this clause is not supplied or NO MAXVALUE is specified, then default values will be used. The defaults are 2^63 - 1 and -1 for ascending and descending sequences, respectively. minvalue The optional clause MINVALUE minvalue d...etermines the minimum value a sequence can generate. If this clause is not supplied or NO MINVALUE is specified, then defaults will be used. The defaults are 1 and -(2^63 - 1) for ascending and descending sequences, respectively. name The name (opti...fied) of the sequence to be created. start The optional clause START WITH start allows the sequence to begin anywhere. The default starting value is minvalue for ascending sequences and maxvalue for descending ones. TEMPORARY or TEMP If specified, the se... - https://man.mtool.work/duckdb/1.3/sql/statements/create_sequence.html
- Timestamp with Time Zone Functions – DuckDB 8896
- 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
...mptz[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . No...tz[, timezone]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 in the provided timezone when bucket_width is a number of months or coarser units, else 2000-01-03...n]) Description Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00+00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00+00:00 . No... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
- Regular Expressions – DuckDB 8744
- 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
...tional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. regexp_extract(string, pattern, name_list[, options]) If string contains the r...tional parameter group ; otherwise, returns the empty string. The group must be a constant value. If no group is given, it defaults to 0. A set of optional options can be set. Example regexp_extract('abc', '([a-z])(b)', 1) Result a regexp_extract(string,...n. A specific capturing group within the pattern can be extracted using the group parameter. If group is not specified, it defaults to 0, extracting the first match with the whole pattern. SELECT regexp_extract ( 'abc' , '.b.' ); -- abc SELECT regexp_ext... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Date Functions – DuckDB 8169
- 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[, origin]) Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a number of months or coarser units, else 2000-01-03 . Note that 2000-01-03 is a Monday...n]) Description Truncate timestamptz to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 when bucket_width is a number of months or coarser units, else 2000-01-03 . Note that 2000-01-03 is a Monday... - https://man.mtool.work/duckdb/1.3/sql/functions/date.html
- Dot Commands – DuckDB 8033
- 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
...Sets the maximum number of rows for display. Only for duckbox mode .maxwidth COUNT Sets the maximum width in characters. 0 defaults to terminal width. Only for duckbox mode .mode MODE TABLE Set output mode .multiline Set multi-line mode (default) .nullva...ber of rows for display ( default : 40 ). Only for duckbox mode . .maxwidth COUNT Sets the maximum width in characters . 0 defaults to terminal width . Only for duckbox mode . .mode MODE ? TABLE ? Set output mode .output : Writing Results to a File By de.... Use either the -e flag for a text file (opened in the default text editor), or the -x flag for a CSV file (opened in the default spreadsheet editor). This is useful for more detailed inspection of query results, especially if there is a relatively larg... - https://man.mtool.work/duckdb/1.3/clients/cli/dot_commands.html
- Configuration – DuckDB 7898
- 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
...ecrets across all backends (e.g., AWS S3) that use them. Configuration Reference Configuration options come with different default scopes : GLOBAL and LOCAL . Below is a list of all available configuration options by scope. Global Configuration Options N...t_order The order type used when none is specified ( ASC or DESC ) VARCHAR ASC default_secret_storage Allows switching the default storage for secrets VARCHAR local_file disable_parquet_prefetching Disable the prefetching mechanism in Parquet BOOLEAN fal...ed for legacy compatibility. VARCHAR NULL zstd_min_string_length The (average) length at which to enable ZSTD compression, defaults to 4096 UBIGINT 4096 Local Configuration Options Name Description Type Default value asof_loop_join_threshold The maximum... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Timestamp Functions – DuckDB 7898
- 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
...estamp[, origin]) Truncate timestamp to a grid of width bucket_width . The grid is anchored at the origin timestamp, which defaults to 2000-01-01 00:00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 . Note that 2000...[, origin]) Description Truncate timestamp to a grid of width bucket_width . The grid includes the origin timestamp, which defaults to 2000-01-01 00:00:00 when bucket_width is a number of months or coarser units, else 2000-01-03 00:00:00 . Note that 2000... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamp.html
DuckDB 1.3 Documentation / man.mtool.work