[GENERAL] regexp match in plpgsql

[Gauthier, Dave]

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.