stackoverflow.com/questions/2568842/jquery-url-validatorblog.mattheworiordan.com/post/13174566389/url-regular-expression-for-links-with-or-without CREATE OR REPLACE FUNCTION

framework.check_http_url(email text)
RETURNS bool AS $$

BEGIN

RETURN email ~* '((((http|https)+:(?:\/\/)+)(?:[\-;:&=\+\$,\w]+@)?)(.)+)';

END $$ LANGUAGE plpgsql;