regexp match in plpgsql

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

V8.3.4 on linux

 

How does one do a regexp match/test in PlPgsql given a text variable containing a regexp and another text variable containt the string to test.  Example that shows what I'm trying to do...

 

declare

 rgxp text;

 str1 text;

 str2 text;

 

begin

 

  rgxp := '[a-zA-Z0-9]';

  str1 := 'ShouldBeOK99';

  str2 := 'Should_Fail_match77';

 

  if(str1 =~ E\rgxp\) then     raise notice '% is a match',str1;     else    raise notice '% is not a match',str1;    end if;

  if(str2 =~ E\rgxp\) then     raise notice '% is a match',str2;     else    raise notice '% is not a match',str2;    end if;

 

end;

$$ language plpgsql

 

 

I would expect to see...

"ShouldBeOK99 is a match"

"Should_Fail_match77 is not a match"

 

Thanks in Advance.