| From: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Counting the number of repeated phrases in a column |
| Date: | 2022-01-25 17:10:25 |
| Message-ID: | CA+i5Jwa5j2m4q6ARt_1U=bWz5=cRqPqqSJ38mYwaP2XF0k_WNg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
There is a short of a function in the standard Postgres to do the following:
It is easy to count the number of occurrence of words, but it is rather
difficult to count the number of occurrence of phrases.
For instance:
A cell of value: 'Hello World' means 1 occurrence a phrase.
A cell of value: 'Hello World World Hello' means no occurrence of any
repeated phrase.
But, A cell of value: 'Hello World World Hello Hello World' means 2
occurrences of 'Hello World'.
'The City of London, London' also has no occurrences of any repeated phrase.
Anyone has got such a function to check out the number of occurrence of any
repeated phrases?
Regards,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Karsten Hilbert | 2022-01-25 17:22:06 | Aw: Counting the number of repeated phrases in a column |
| Previous Message | Rob Sargent | 2022-01-25 16:40:53 | Re: Robust ways for checking allowed values in a column |