Results of 1 - 2 of about 2 for disambiguate (0.001 sec.)
- Union Type 11228
- 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
...ontains multiple members of the same type, e.g., a FLOAT → UNION(i INTEGER, num INTEGER) is always ambiguous. So how do we disambiguate if we want to create a UNION with multiple members of the same type? By using the union_value function, which takes a keyw...ue(num := 2::INTEGER) will create a UNION with a single member of type INTEGER with the tag num . This can then be used to disambiguate in an explicit (or implicit, read on below!) UNION to UNION cast, like CAST(union_value(b := 2) AS UNION(a INTEGER, b INTE... - https://man.mtool.work/duckdb/2.0/sql/data_types/union.html
- Timestamp Types 7485
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...interpreted as simply manipulating tuple fields following nominal 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 unambiguou... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work