Results of 1 - 10 of about 49 for strings (0.004 sec.)
- Text Functions – DuckDB 13734
- 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
...ive values are accepted. string LIKE target Returns true if the string matches the like specifier (see Pattern Matching ). string SIMILAR TO regex Returns true if the string matches the regex (see Pattern Matching ). string ^@ search_string Returns true...if string begins with search_string . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . array_...ns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . concat_ws(separator, string, ...) Concatenates many stri... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Text Types – DuckDB 12436
- 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 and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Text Types In DuckDB, strings can be stored in the VARCHAR field. The field allows storage of Unicode characters. Internally, the data is encoded as UTF...equired and has no effect on the system. Specifying the length will not improve performance or reduce storage space of the strings in the database. These variants variant is supported for compatibility reasons with other systems that do require a length...to be specified for strings. If you wish to restrict the number of characters in a VARCHAR column for data integrity reasons the CHECK constraint shou... - https://man.mtool.work/duckdb/1.3/sql/data_types/text.html
- Timestamp Types – DuckDB 10942
- 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
...al temporal logic. It is a common data cleaning problem to disambiguate such observations, which may also be stored in raw strings without time zone specification or UTC offsets, into unambiguous TIMESTAMP WITH TIME ZONE instants. One possible solution...to this is to append UTC offsets to strings, followed by an explicit cast to TIMESTAMP WITH TIME ZONE . Alternatively, a TIMESTAMP WITHOUT TIME ZONE may be created fi...then be combined with a time zone specification to obtain a time zone aware TIMESTAMP WITH TIME ZONE . Conversion between Strings and Naïve / Time Zone-Aware Timestamps The conversion between strings without UTC offsets or IANA time zone names and WITH... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- Result Verification – DuckDB 9432
- 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
...st runner does not use or need them internally – therefore, only I should be used to denote columns. NULL Values and Empty Strings Empty lines have special significance for the SQLLogic test runner: they signify an end of the current statement or query....For that reason, empty strings and NULL values have special syntax that must be used in result verification. NULL values should use the string NULL , and...empty strings should use the string (empty) , e.g.: query II SELECT NULL , '' ---- NULL ( empty ) Error Verification In order to signify... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/result_verification.html
- Schema – DuckDB 9010
- 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
...While it is always possible to use string types ( VARCHAR , etc.) to encode more specific values, this is not recommended. Strings use more space and are slower to process in operations such as filtering, join, and aggregation. When loading CSV files, y...up more memory during processing. Bestpractice Use the most restrictive types possible when creating columns. Avoid using strings for encoding more specific data items. Microbenchmark: Using Timestamps We illustrate the difference in aggregation speed...results show that using the DATETIME value yields smaller storage sizes and faster processing. Microbenchmark: Joining on Strings We illustrate the difference caused by joining on different types by computing a self-join on the LDBC Comment table at sc... - https://man.mtool.work/duckdb/1.3/guides/performance/schema.html
- Execution Format – DuckDB 9010
- 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
...contents of the Vector. Every type of Vector can convert to this format. Complex Types String Vectors To efficiently store strings, we make use of our string_t class. struct string_t { union { struct { uint32_t length ; char prefix [ 4 ]; char * ptr ; }...pointer ; struct { uint32_t length ; char inlined [ 12 ]; } inlined ; } value ; }; Short strings ( <= 12 bytes ) are inlined into the structure, while larger strings are stored with a pointer to the data in the auxiliar...y check for null-pointers. The prefix is used for comparisons as an early out (when the prefix does not match, we know the strings are not equal and don't need to chase any pointers). List Vectors List vectors are stored as a series of list entries toge... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Blob Functions – DuckDB 8904
- 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
...cribes functions and operators for examining and manipulating BLOB values . Name Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . base64...(blob) Converts a blob to a base64 encoded string. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . decode(blob) Converts blob to VARCHAR . Fails if blob is...a blob. unhex(value) Converts a value from hexadecimal representation to a blob. arg1 || arg2 Description Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list1, list2) . Exampl... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Collations – DuckDB 8799
- 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
...y want to use when performing sorting and comparison operations. By default, the BINARY collation is used. That means that strings are ordered and compared based only on their binary contents. This makes sense for standard ASCII characters (i.e., the le...he NOCASE collation. For example, to use the German collation rules you could use the following code snippet: CREATE TABLE strings ( s VARCHAR COLLATE DE ); INSERT INTO strings VALUES ( 'Gabel' ), ( 'Göbel' ), ( 'Goethe' ), ( 'Goldmann' ), ( 'Göthe' ),...( 'Götz' ); SELECT * FROM strings ORDER BY s ; "Gabel", "Göbel", "Goethe", "Goldmann", "Göthe", "Götz" 関連キーワード names collation collations Collations... - https://man.mtool.work/duckdb/1.3/sql/expressions/collations.html
- PostgreSQL Compatibility – DuckDB 8693
- 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
...following: x 1 2 Implicit Casting on Equality Checks DuckDB performs implicit casting on equality checks, e.g., converting strings to numeric and boolean values. Therefore, there are several instances, where PostgreSQL throws an error while DuckDB succe...statement is only used to rebuild statistics. For instruction on reclaiming space, refer to the “Reclaiming space” page . Strings Since version 1.3.0, DuckDB escapes characters such as ' in strings serialized in nested data structures. PostgreSQL does...['\''] Functions regexp_extract Function Unlike PostgreSQL's regexp_substr function, DuckDB's regexp_extract returns empty strings instead of NULL s when there is no match. to_date Function DuckDB does not support the to_date PostgreSQL date formatting... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- List Functions – DuckDB 8587
- 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
...list comprehension can be used to compute expressions over elements in a list. For example: SELECT [ lower ( x ) FOR x IN strings ] AS strings FROM ( VALUES ([ 'Hello' , '' , 'World' ])) t ( strings ); strings [hello, , world] SELECT [ upper ( x ) FOR...x IN strings IF len ( x ) > 0 ] AS strings FROM ( VALUES ([ 'Hello' , '' , 'World' ])) t ( strings ); strings [HELLO, WORLD] List compr... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
DuckDB 1.3 Documentation / man.mtool.work