Results of 1 - 10 of about 17 for representation (0.005 sec.)
- Text Functions – DuckDB 14018
- 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
.... width defaults to 80. base64(blob) Converts a blob to a base64 encoded string. bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a string . char_length(string) Number of characters in string . character_length(str...rmat, ...) Formats a string using the fmt syntax . formatReadableDecimalSize(integer) Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.). formatReadableSize(integer) Converts integer to a human-readable rep...ntation using units based on powers of 2 (KiB, MiB, GiB, etc.). format_bytes(integer) Converts integer to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). from_base64(string) Converts a base64 encoded string to a characte... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Blob Functions – DuckDB 12207
- 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
...4(string) Converts a base64 encoded string to a character string ( BLOB ). from_binary(value) Converts a value from binary representation to a blob. from_hex(value) Converts a value from hexadecimal representation to a blob. hex(blob) Converts blob to VARCHAR...ncoded string. to_hex(blob) Converts blob to VARCHAR using hexadecimal encoding. unbin(value) Converts a value from binary representation to a blob. unhex(value) Converts a value from hexadecimal representation to a blob. arg1 || arg2 Description Concatenates...haracter string ( BLOB ). Example from_base64('QQ==') Result A from_binary(value) Description Converts a value from binary representation to a blob. Example from_binary('0110') Result \x06 Alias unbin from_hex(value) Description Converts a value from hexadecim... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Execution Format – DuckDB 8880
- 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
...DuckDB supports different vector formats , which allow the system to store the same logical data with a different physical representation . This allows for a more compressed representation, and potentially allows for compressed execution throughout the system....y stored as a contiguous array, this is the standard uncompressed vector format. For flat vectors the logical and physical representations are identical. Constant Vectors Constant vectors are physically stored as a single constant value. Constant vectors are u...d recursively. For nested list vectors, the child of a list vector is again a list vector. For example, consider this mock representation of a Vector of type BIGINT[][] : { "type" : "list" , "data" : "list_entry_t" , "child" : { "type" : "list" , "data" : "lis... - https://man.mtool.work/duckdb/1.3/internals/vector.html
- Date Format Functions – DuckDB 8880
- 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
...SV files, displaying output to the user or transferring information between programs. Because there are many possible date representations, these functions accept a format string that describes how the date or timestamp should be structured. strftime Examples...unday, Monday, … %b Abbreviated month name. Jan, Feb, …, Dec %B Full month name. January, February, … %c ISO date and time representation 1992-03-02 10:30:20 %d Day of the month as a zero-padded decimal. 01, 02, …, 31 %-d Day of the month as a decimal number....o there can be week 00. Note that this is not compliant with the week date standard in ISO-8601. 00, 01, …, 53 %x ISO date representation 1992-03-02 %X ISO time representation 10:30:20 %y Year without century as a zero-padded decimal number. 00, 01, …, 99 %-y... - https://man.mtool.work/duckdb/1.3/sql/functions/dateformat.html
- Spatial Functions – DuckDB 8483
- 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
...TRING from a list of POINT geometries ST_MakePolygon Create a POLYGON from a LINESTRING shell ST_MakeValid Returns a valid representation of the geometry ST_MaximumInscribedCircle Returns the maximum inscribed circle of the input geometry, optionally with a to...collection of input linestrings and adding additional vertices where they intersect. ST_Normalize Returns the "normalized" representation of the geometry ST_NumGeometries Returns the number of component geometries in a collection geometry. ST_NumInteriorRings...into a MULTIPOINT ST_Polygon2DFromWKB Deserialize a POLYGON_2D from a WKB encoded blob ST_Polygonize Returns a polygonized representation of the input geometries ST_QuadKey Compute the quadkey for a given lon/lat point at a given level. ST_ReducePrecision Retu... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Writing Tests – DuckDB 8379
- 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
...────────────────┘ test_vector_types has an optional argument called all_flat of type BOOL . This only affects the internal representation of the vector. FROM test_vector_types ( NULL :: ROW ( i INTEGER , j VARCHAR , k DOUBLE ), NULL :: TIMESTAMP , all_flat = t...rue ); -- the output is the same as above but with a different internal representation 関連キーワード vector tests types struct DuckDB table integer Tests also unittest written client columns type flat Develop... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/writing_tests.html
- Values – DuckDB 8173
- 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
...kdb_value containing a UUID Return Value A duckdb_uhugeint representing the UUID value duckdb_get_varchar Obtains a string representation of the given value. The result must be destroyed with duckdb_free . Syntax char * duckdb_get_varchar ( duckdb_value value...e. index : The index of the child. Return Value The child as a duckdb_value. duckdb_value_to_string Returns the SQL string representation of the given value. Syntax char * duckdb_value_to_string ( duckdb_value value ); Parameters value : A duckdb_value. Return...Value The SQL string representation as a null-terminated string. The result must be freed with duckdb_free . 関連キーワード duckdb create input uint timestamp... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- CSV Auto Detection – DuckDB 8173
- 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
...should be read. As part of the auto-detection, the system tries to figure out if dates and times are stored in a different representation. This is not always possible – as there are ambiguities in the representation. For example, the date 01-02-2000 can be par... - https://man.mtool.work/duckdb/1.3/data/csv/auto_detection.html
- Spatial Extension – DuckDB 7879
- 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
...GIS tooling, this type probably works very different from what you'd expect. On the surface, the GEOMETRY type is a binary representation of “geometry” data made up out of sets of vertices (pairs of X and Y double precision floats). But what makes it somewhat... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/overview.html
- Functions – DuckDB 7879
- 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
...[blob] [BLOB] Convert a blob to a base64 encoded string bin scalar VARCHAR [value] [VARCHAR] Converts the value to binary representation bit_count scalar TINYINT [x] [TINYINT] Returns the number of bits that are set bit_length scalar BIGINT [col0] [VARCHAR] N... - https://man.mtool.work/duckdb/1.3/sql/functions/overview.html
DuckDB 1.3 Documentation / man.mtool.work