Yup, I forgot the "^".
Works now.
Thanks !
From: David Johnston [mailto:pol...@yahoo.com]
Sent: Tuesday, February 22, 2011 7:26 PM
To: Gauthier, Dave; pgsql-general@postgresql.org
Subject: RE: [GENERAL] regexp match in plpgsql
You are trying to check the entire string to ensur
ing
"true" for both tests then this is the reason and the solution.
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave
Sent: Tuesday, February 22, 2011 5:56 PM
To: pgsql-general@postgresql.org
Subject: [GEN
On 23 February 2011 11:55, Gauthier, Dave wrote:
> I would expect to see...
>
> "ShouldBeOK99 is a match"
>
> "Should_Fail_match77 is not a match"
Why would you expect that? Both strings match at least one
character from the character class?
Cheers,
Andrej
--
Sent via pgsql-general mailing l
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 := 'Sh
