Results of 1 - 1 of about 1 for comparator (0.000 sec.)
- Variant Functions 9414
- 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
...bject. variant_contains(haystack, needle) Return whether the needle VARIANT is contained in the haystack VARIANT . variant_comparator(v) Return a binary sort key that orders a VARIANT value by the logical ordering of VARIANT values. variant_normalize(v) Re...variant_contains('{"user": {"id": 42}}'::JSON::VARIANT, '{"user": {"id": 42}}'::JSON::VARIANT) | | Result | true | variant_comparator(v) | Description | Return a binary sort key (a BLOB ) that orders a VARIANT value according to the logical ordering of VAR...ently 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 type bucket (for example, booleans b... - https://man.mtool.work/duckdb/2.0/sql/functions/variant.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work