Help Center> GaussDB> Distributed_8.x> Stored Procedures> Advanced Packages> Secondary Encapsulation APIs (Recommended)> DBE_MATCH
Updated on 2024-06-03 GMT+08:00
View PDF

DBE_MATCH

API Description

Table 1 provides all APIs supported by the DBE_MATCH package.

Table 1 DBE_MATCH

API

Description

DBE_MATCH.EDIT_DISTANCE_SIMILARITY

Compares the difference between two character strings (minimum steps of deletion, addition, and conversion) and normalizes the difference to a value ranging from 0 to 100. The value 100 indicates that the two character strings are the same, and the value 0 indicates that the two character strings are different.
  • DBE_MATCH.EDIT_DISTANCE_SIMILARITY

Compares the difference between two character strings (minimum steps of deletion, addition, and conversion) and normalizes the difference to a value ranging from 0 to 100. The value 100 indicates that the two character strings are the same, and the value 0 indicates that the two character strings are completely different. The DBE_MATCH.EDIT_DISTANCE_SIMILARITY function prototype is as follows:

1
2
3
4
 
DBE_MATCH.EDIT_DISTANCE_SIMILARITY(
    str1 IN text,
    str2 IN text
)returns integer ;
Table 2 DBE_MATCH.EDIT_DISTANCE_SIMILARITY parameters

Parameter

Description

str1

First character string. If the value is null, 0 is returned.

str2

Second character string. If the value is null, 0 is returned.