Short postgres function for regex check

Question

The definition below seems heavy for what it does. Can this be written more succinctly?

CREATE OR REPLACE FUNCTION "check_email"(email TEXT)
  RETURNS BOOLEAN AS $$
BEGIN
  RETURN email ~* '^[A-Za-z0-9._%+$-]+@[a-zA-Z0-9-]+([.][A-Za-z0-9-]+)+$';
END;
$$ LANGUAGE plpgsql;

I am not interested in shortening the regex, just the definition boilerplate.

klin · Accepted Answer · 2017-07-11 09:58:52Z

1

You can use SQL instead of PLPGSQL language:

CREATE FUNCTION check_email(text)
RETURNS boolean AS $$
    SELECT $1 ~* '^[A-Za-z0-9._%+$-]+@[a-zA-Z0-9-]+([.][A-Za-z0-9-]+)+$';
$$ LANGUAGE sql;

answered Jul 11, 2017 at 9:58

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Short postgres function for regex check

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related