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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
