Обсуждение: create function

I am running linux with postgres and want to be able to count the amount of
times a phrase/word is repeated in a field. and thought the only way of
doing this would be to create a function to pass through text and count the
amount of times a word/phrase is repeated in this

can anyone assist with this?

thanks

Rob

On Tuesday, June 17, 2003, at 08:45  AM, Rob Larter wrote:

> I am running linux with postgres and want to be able to count the
> amount of
> times a phrase/word is repeated in a field. and thought the only way of
> doing this would be to create a function to pass through text and
> count the
> amount of times a word/phrase is repeated in this
>
> can anyone assist with this?

This is not a specific answer to your question, but perhaps you can
find some example functions that will point you in the right
direction. The "PostgreSQL Cookbook Pages" is a great source of
examples:

http://www.brasileiro.net:8080/postgres/cookbook/

-heath