Union Functions
| Name | Description |
union.tag | Dot notation serves as an alias for union_extract. |
union_extract(union, 'tag') | Extract the value with the named tags from the union. NULL if the tag is not currently selected. |
union_value(tag := any) | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. |
union_tag(union) | Retrieve the currently selected tag of the union as an Enum. |
| Description | Dot notation serves as an alias for union_extract. |
| Example | (union_value(k := 'hello')).k |
| Result | string |
| Description | Extract the value with the named tags from the union. NULL if the tag is not currently selected. |
| Example | union_extract(s, 'k') |
| Result | hello |
| Description | Create a single member UNION containing the argument value. The tag of the value will be the bound variable name. |
| Example | union_value(k := 'hello') |
| Result | 'hello'::UNION(k VARCHAR) |
| Description | Retrieve the currently selected tag of the union as an Enum. |
| Example | union_tag(union_value(k := 'foo')) |
| Result | 'k' |