Help Center/ GaussDB/ Centralized_3.x/ Stored Procedure/ Advanced Packages/ Secondary Encapsulation Interfaces (Recommended)/ DBE_MATCH
Updated on 2024-05-07 GMT+08:00
View PDF

DBE_MATCH

Interface Description

Table 1 provides all interfaces supported by the DBE_MATCH package.

Table 1 DBE_MATCH

Interface

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 interface 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.