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

On Fri, Feb 15, 2008 at 11:09 AM, Emi Lu <emilu@encs.concordia.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.