Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Stored Procedure/ Advanced Packages/ Secondary Encapsulation APIs (Recommended)/ DBE_MATCH
Updated on 2024-08-20 GMT+08:00
View PDF
Share

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 prototype of the DBE_MATCH.EDIT_DISTANCE_SIMILARITY function 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.