Results of 1 - 10 of about 10 for lowercase (0.004 sec.)
- Keywords and Identifiers 14141
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...fiers in a case-insensitive manner, it preserves the cases of these identifiers. That is, each character's case (uppercase/lowercase) is maintained as originally specified by the user even if a query uses different cases when referring to the identifier....non-quoted identifiers are folded. It accepts the following values: 'preserve_case' (default): keep the case as written. 'lowercase' : turn non-quoted identifiers into lowercase. 'uppercase' : turn non-quoted identifiers into uppercase. For backward comp...atibility, the Boolean values true and false are also accepted and map to 'preserve_case' and 'lowercase' , respectively. For example, with preserve_identifier_case set to 'lowercase' , all non-quoted identifiers are turned int... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Full-Text Search Extension 9081
- 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
...ARCHAR Regular expression of patterns to be ignored. Defaults to '(\\.|[^a-z])+' , ignoring all 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 existing index on a table. Defaults to 0 incremental BOOLEAN Whet... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Profile and Monitor 8616
- Overview The Rust client can observe a running or completed query: it can retrieve per-operator profiling metrics after a query runs, and interrupt a long-running query from another thread. Both are shown below. Profiling Profiling must be
...ofilingInfo> , which is None when profiling is not enabled. ProfilingInfo is a tree whose metrics are grouped and named in lowercase (see the metrics list ): the root's children are the root plan operator, with metrics such as type , timing and intermedia... - https://man.mtool.work/duckdb/2.0/clients/rust/profiling.html
- Migrating to DuckDB 2.0 8616
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...tting The preserve_identifier_case setting changed from a BOOLEAN to a VARCHAR with the values 'preserve_case' (default), 'lowercase' and 'uppercase' . The old values true and false are still accepted and map to 'preserve_case' and 'lowercase' , respectiv... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Text Functions 8616
- 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
...nbin . from_hex(value) Alias for unhex . greatest(arg1, ...) Returns the largest value in lexicographical order. Note that lowercase characters are considered larger than uppercase characters and collations are not supported. hash(value, ...) Returns a UB...arg1, ...) Returns the smallest value in lexicographical order. Note that uppercase characters are considered smaller than lowercase characters and collations are not supported. left(string, count) Extracts the left-most count characters. left_grapheme(st...tive matching. escape_character is used to search for wildcard characters in the string . lower(string) Converts string to lower case. lpad(string, count, character) Pads the string with the character on the left until it has count characters. Truncates t... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Editing 8473
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...Ctrl + W Delete previous word Alt + C Convert next word to titlecase Alt + D Delete next word Alt + L Convert next word to lowercase Alt + R Delete all text Alt + T Swap current word with previous word Alt + U Convert next word to uppercase Alt + Backspac... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- Profile and Monitor 8313
- Overview The Go client can observe query execution: it can retrieve per-operator profiling metrics after a query runs, and register a log storage that receives DuckDB's log messages. Both are described below. Profiling Profiling information
...Each node has a Metrics map of metric name to value and a Children slice of child nodes. Metrics are grouped and named in lowercase: the root's children are the root plan operator, whose metrics include type and timing , followed by one node per metric g... - https://man.mtool.work/duckdb/2.0/clients/go/profiling.html
- PostgreSQL Compatibility 8009
- DuckDB's SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by
...n interfacing with other tools (e.g., Parquet, Pandas) that are case-sensitive by default – since all identifiers would be lowercased all the time. Therefore, DuckDB achieves case insensitivity by making identifiers fully case insensitive throughout the s...avior of lowercasing identifiers is accessible using the preserve_identifier_case option : SET preserve_identifier_case = 'lowercase'; CREATE TABLE MyTaBLe (x INTEGER); SELECT table_name FROM duckdb_tables(); table_name mytable However, the case insensiti... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Numeric Types 7848
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...ough the UUID type. These use 128 bits and are represented internally as HUGEINT values. When printed, they are shown with lowercase hexadecimal characters, separated by dashes as follows: ⟨12345678⟩-⟨1234⟩-⟨1234⟩-⟨1234⟩-⟨1234567890ab⟩ (using 36 character... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Configuration 7544
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ect BOOLEAN false preserve_identifier_case How to fold non-quoted identifiers. 'preserve_case' keeps the case as written, 'lowercase' lowercases them, 'uppercase' uppercases them. VARCHAR preserve_case preserve_insertion_order Whether or not to preserve i... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work