The output contains the ‘#eduCBA’ and ‘# PostgreSQL’ string, which means matching strings with regular expressions defined in a pattern. We can extract substrings from the above text using the PostgreSQL REGEXP_MATCHES() function as follows, which returns all strings containing hashtags in the given string.Ĭode: SELECT REGEXP_MATCHES('#EduCBA is best learning platform for #PostgreSQL', '#(+)', 'g') ‘#EduCBA is the best learning platform for #PostgreSQL.’ We are having a post related to trending content for current educational views as follows:
0 Comments
Leave a Reply. |