Re: Function to return number of words in a string?

You can use a combination of regex
(http://www.postgresql.org/docs/8.0/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
and strpos inside a plpgsql function to do this, but using plpython or
plperl might be faster. A C function would possibly be faster still.

On Mon, May 09, 2005 at 11:21:28AM -0500, Peter Fein wrote:
> Hiya-
>
> I'm looking for a function to return the number of words in a string,
> split on whitespace.  I'm coming from python, so I may just write it in
> that but I wanted to check first.  In python, one would write:
>
> s="some string or other"
> len(s.split())
>
> Thanks!
>
> --
> Peter Fein                 pfein@pobox.com                 773-575-0694
>
> Basically, if you're not a utopianist, you're a schmuck. -J. Feldman
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"