Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Breaks a CHAR string into terms and returns each term as a row along with its position.
sa_char_terms( ' text' [, 'config-name' [, 'owner' ] ] )
The CHAR string you are parsing.
The text configuration object to apply when processing the string. The default value is 'default_char'.
The owner of the specified text configuration object. The default value is NULL, and the current user is assumed if the
owner is not specified or if NULL is specified.
You can use this system procedure to find out how a string is interpreted when the settings for a text configuration object
are applied. This can be helpful when you want to know what terms would be dropped during indexing or from a query string.
The following statement returns the terms in the CHAR string, It's a work-at-home day!, using the default CHAR text configuration
CALL sa_char_terms ('It''s a work-at-home day!', 'default_char', 'sys');