This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a small demonstration on how to parse the hyphenated words in PostgreSQL.
Recently, I got a result set and where few columns have hyphenated words. Now, we need analysis on hyphenated words.
At first glance, it looks like string operation, but it is one type of string parsing which we can do using ts_debug.
We can use ts_debug for text Parsing.
Check the below example:
1 2 3 4 5 |
SELECT alias ,description ,token FROM ts_debug('yellow-red-orange'); |
Result:
Leave a Reply