create function

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