Re: String function to Find how many times str2 is in str1?

On Fri, Feb 15, 2008 at 11:09 AM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> Str1 = "test test caa dtest testing EndofString";
> Str2 = " ";
>
> select funcName(Str1, Str2);
>
> return 5

CREATE OR REPLACE FUNCTION
FOOBAR(TEXT,TEXT)
RETURNS INT AS $$
SELECT(LENGTH($1) - LENGTH(REPLACE($1, $2, ''))) / LENGTH($2) ;
$$ LANGUAGE SQL IMMUTABLE;

SELECT FOOBAR('test test caa dtest testing EndofString', ' ');

foobar
--------
5
(1 row)

Good luck.