Results of 1 - 10 of about 24 for representation (0.003 sec.)
- Geometry Functions 13994
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...:GEOMETRY true Built-in Geometry Functions Name Description ST_GeomFromWKB Creates a geometry from Well-Known Binary (WKB) representation ST_AsWKB Returns the Well-Known Binary (WKB) representation of the geometry ST_AsWKT Returns the Well-Known Text (WKT) rep...m (CRS) identifier of the geometry ST_GeomFromWKB function | Description | Creates a geometry from Well-Known Binary (WKB) representation | | Example | ST_GeomFromWKB('\x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\xF0?\x00\x00\x00\x00\x00\x00\x00@') | | Result...| POINT(1 2) | ST_AsWKB function | Description | Returns the Well-Known Binary (WKB) representation of the geometry | | Example | ST_AsWKB('POINT(1 2)'::GEOMETRY) | | Result | \x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\x... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Text Functions 11743
- 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
...aracters when x = max . width defaults to 80. base64(blob) Alias for to_base64 . bin(string) Converts the string to binary representation. bit_length(string) Number of bits in a string . char_length(string) Alias for length . character_length(string) Alias for...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.). format_bytes(integer) Converts integer to a human-readable represent...NT with the hash of the value . Note that this is not a cryptographic hash. hex(string) Converts the string to hexadecimal representation. ilike_escape(string, like_specifier, escape_character) Returns true if the string matches the like_specifier (see Pattern... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Execution Format 10125
- Vector is the container format used to store in-memory data during execution. DataChunk is a collection of Vectors, used for instance to represent a column list in a PhysicalProjection operator. Data Flow DuckDB uses a vectorized query exec
...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": "list_entry_... - https://man.mtool.work/duckdb/2.0/internals/vector.html
- Blob Functions 10125
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...4(blob) Converts a blob to a base64 encoded string. to_hex(blob) Alias for hex . 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 | Concatena...le | to_base64('A'::BLOB) | | Result | QQ== | | Alias | base64 | unbin(value) | Description | Converts a value from binary representation to a blob. | | Example | unbin('0110') | | Result | \x06 | | Alias | from_binary | unhex(value) | Description | Converts a...value from hexadecimal representation to a blob. | | Example | unhex('2A') | | Result | * | | Alias | from_hex |... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Date Format Functions 9140
- The strftime and strptime functions can be used to convert between DATE / TIMESTAMP values and strings. This is often required when parsing CSV 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...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...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. Numbers 00 to 68 a... - https://man.mtool.work/duckdb/2.0/sql/functions/dateformat.html
- Variant Functions 9140
- This section describes functions that operate on the VARIANT type . New Most variant_* functions were introduced in DuckDB 2.0. The variant_extract , variant_normalize and variant_typeof functions were already available in DuckDB 1.5. Name
...ry sort key that orders a VARIANT value by the logical ordering of VARIANT values. variant_normalize(v) Return a canonical representation of a VARIANT value, so that values representing the same data share the same form. variant_group_object(key, value) Aggreg...hat VARIANT s compare and sort consistently with the corresponding native DuckDB types, rather than by their internal byte representation. | | Example | variant_comparator({'a': 1, 'b': 2}::VARIANT) | | Result | A BLOB sort key | Values are ordered first by ty...: SELECT i FROM range(-2, 2) t(i) ORDER BY i::VARIANT; i -2 -1 0 1 variant_normalize(v) | Description | Return a canonical representation of a VARIANT value. Two VARIANT values that represent the same data normalize to the same result, regardless of how they w... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
- Writing Tests 8640
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...────────────────┘ 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 = true); -- the...output is the same as above but with a different internal representation... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
- Spatial Functions 8140
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...om an pair of floating point numbers. 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/2.0/core_extensions/spatial/functions.html
- PostgreSQL Extension Functions 8023
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...= false) postgres_hstore_get postgres_hstore_get(hstore_string VARCHAR, hstore_key VARCHAR) -> VARCHAR Parses the external representation of and PostgreSQL hstore column and returns the value of the specified hstore key. Parameters hstore_string ( VARCHAR ): P...et('a=>b, c=>d', 'a') postgres_hstore_to_json postgres_hstore_to_json(hstore_string VARCHAR) -> JSON Converts the external representation of and PostgreSQL hstore column into JSON . Parameters hstore_string ( VARCHAR ): PostgreSQL hstore value in key => value... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Geometry Data Type 8023
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...ing for complex geometries that combine points, lines, and polygons or even other nested geometry collections. The textual representation of geometries uses "Well-Known Text" (WKT) format. Geometries can be cast to and from WKT strings, so you can use string l...ions, but they are mostly useful for representing the result of topological operations that don't have a valid geometrical representation (e.g., the intersection of two non-overlapping geometries is an empty geometry). Geometry Storage Internally GEOMETRY valu...y benefit of shredding is significantly improved compression, but in the future we plan to add ways to expose the shredded representation directly to the execution engine without having to "reassemble" the geometry back into binary again. The following example... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
DuckDB 2.0 Documentation / man.mtool.work