Help Center/GaussDB/Developer Guide(Distributed_V2.0-2.x)/Stored Procedures/Advanced Packages/Secondary Encapsulation APIs (Recommended)/DBE_MATCH
Updated on 2025-08-19 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 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 API 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.