Results of 1 - 7 of about 7 for uppercase (0.003 sec.)
- Keywords and Identifiers 13359
- 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
...ats identifiers 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 id...ng 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 compatibility, the Boolean values true and false are also acce...E tbl AS SELECT cos(pi()) AS CosineOfPi; SELECT CosineOfPi FROM tbl; cosineofpi -1.0 With preserve_identifier_case set to 'uppercase' , they are turned into uppercase, so the table above would be named TBL and its column COSINEOFPI . The setting is applie... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Text Functions 9051
- 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
...t(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 UBIGINT with the hash of the value . Note that thi...tch found. lcase(string) Alias for lower . least(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...urns an INTEGER representing the unicode codepoint of the first character in the string . upper(string) Converts string to upper case. url_decode(string) Decodes a URL from a representation using Percent-Encoding . url_encode(string) Encodes a URL to a re... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Editing 8869
- 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
...t 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 + Backspace Delete previous word Alt + \ Delete spaces around cursor Completing Key Action Tab Autocomplete. When auto... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- PEG Parser 8669
- New Starting with DuckDB 2.0, the PEG parser is the default parser. In earlier versions it was an experimental, opt-in feature enabled with enable_peg_parser() , which is no longer required or available. DuckDB uses a parser based on PEG (
...straints on ALTER TABLE ... ADD COLUMN , such as UNIQUE , are rejected by the transformer. The preserve_identifier_case = 'uppercase' option is a DuckDB 2.0 feature; the legacy grammar treats it as 'preserve_case' . Warning Newer and more powerful syntax,... - https://man.mtool.work/duckdb/2.0/sql/peg_parser.html
- Migrating to DuckDB 2.0 8106
- 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
...ve_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' , respectively. S3 URL Para... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
- Configuration 7742
- 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
...entifier_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 insertion order. If set to fal... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- JSON Processing Functions 7742
- 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
...a JSON array into a LIST , the result can be processed further with lambda functions . For example, use list_transform to uppercase each extracted species name: SELECT list_transform(j->>'$.species[*]', lambda s: upper(s)) AS names FROM example; names [D... - https://man.mtool.work/duckdb/2.0/data/json/json_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work