Results of 1 - 5 of about 5 for Unions (0.002 sec.)
- Union Type 12795
- A UNION type (not to be confused with the SQL UNION operator ) is a nested type capable of holding one of multiple “alternative” values, much like the union in C. The main difference is that these UNION types are tagged unions and thus alwa
...from the UNION as an ENUM . SELECT union_tag(u) AS t FROM tbl1; t num str str Union Casts Compared to other nested types, UNION s allow a set of implicit casts to facilitate unintrusive and natural usage when working with their members as “subtypes”....d with two principles in mind, to avoid ambiguity and to avoid casts that could lead to loss of information. This prevents UNION s from being completely “transparent”, while still allowing UNION types to have a “supertype” relationship with their membe...all use their corresponding VARCHAR casts. Since everything can be cast to VARCHAR , this is “safe” in a sense. Casting to Unions A type can always be implicitly cast to a UNION if it can be implicitly cast to one of the UNION member types. If there ar... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Types API 8861
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...ltypes.DuckDBPyType({'a': str, 'b': int})) STRUCT(a VARCHAR, b BIGINT) Union[type_1, ... type_n] typing.Union objects, and unions written as type_1 | type_2 , map to a UNION type of the provided types. import duckdb.sqltypes from typing import Union pr... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Typecasting 8346
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...s. This logic also applies recursively to potentially nested structs. SELECT {'outer1': {'inner1': 42, 'inner2': 42}} AS c UNION SELECT {'outer1': {'inner2': 'hello', 'inner3': 'world'}, 'outer2': '100'} AS c; SELECT [{'a': 42}, {'b': 84}]; Unions Unio... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Spatial Functions 8089
- 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
...a coverage geometry ST_CoverageSimplify_Agg Simplifies a set of geometries while maintaining coverage ST_CoverageUnion_Agg Unions a set of geometries while maintaining coverage ST_Envelope_Agg Alias for ST_Extent_Agg . ST_Extent_Agg Computes the minima...he coverage is also simplified, but this can be controlled with the optional third simplify_boundary parameter. ST_CoverageUnion Signature GEOMETRY ST_CoverageUnion (geoms GEOMETRY[]) Description Union all geometries in a polygonal coverage into a sing...M (SELECT ST_GeomFromText('POINT( 170370.718 11572.405 )') AS bng) t; ---- POINT (-5.203046090608746 49.96006137018598) ST_Union Signature GEOMETRY ST_Union (geom1 GEOMETRY, geom2 GEOMETRY) Description Returns the union of two geometries ST_VoronoiDiag... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Data Type 7813
- 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
...itional geometry functions provided by the extension, including functions for calculating areas, distances, intersections, unions, and much more.... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work