LABEL_OF

Return the label of an entity 'match'.

Parameter Type Description
match_column
anyuri
Return the label of a match value
Returns: string

Example

query:

SELECT LABEL_OF(us_state_or_territory) AS state
  FROM just_states
 LIMIT 10

results:

state
Virginia
Texas
Oklahoma
Virginia
South Carolina
California
Alabama
Maine
New Hampshire
Massachusetts

This function is especially useful for cases where you need to ensure that the proper label is being returned (as opposed to the “blue bubble” uri)