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

[Rodrigo E. De León Plicet]

On Fri, Feb 15, 2008 at 11:09 AM, Emi Lu <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster