Re: Function to return number of words in a string? - Mailing list pgsql-general

On Mon, May 09, 2005 at 11:49:41AM -0500, Jim C. Nasby wrote:
> 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())

    abacus=> select array_upper(string_to_array('one two three four', ' '), 1);
     array_upper
    -------------
               4
    (1 row)

Not that this is a _good_ way of doing it, but it is possible without resorting
to a PL.

Cheers,
  Steve