On Mon, Dec 13, 2010 at 7:24 AM, Henrique de Lima Trindade <henrique@xxxxxxxxxxxxx> wrote: > Your example works perfectly. But, I need Your help with on another situation. > We're trying to create a plpgsql function with the expression. But, I'm getting a syntax error: You're using $$ quoting for the function, and $$ quoting for the string in the regexp. Think of it like you're trying to embed a ' in a string delimited by ' also. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general