word_stem() function

The word_stem() function returns the root stem of a specified varchar word. For example, the words fishing, fished, and fisher all return fish.

Syntax

The word_stem() function has the following syntax:

varchar = word_stem(varchar word [, int1 algorithm]);

The word value specifies the varchar word whose root stem you want.

The algorithm value has just one option, 100, which indicates the Porter algorithm. This is the default, so you do not need to specify an algorithm.

Returns

The function returns the root stem of the varchar word.

Example

select word_stem('fishing');
 WORD_STEM
-----------
 fish
(1 row)