How to compare regular expressions correctly in postgreSQL?

Question

Trying to compare regular expressions from mine database to function parameters and got the following false result .. But if i go to https://regexr.com/ and try to compare with the same regular expression and the nickname i got match ..

Need your help , what i am doing wrong ?

select nickname_r from regex; // Here the regex that below

select '([0-9a-zA-Z.-_\=+\@]{2,15})' ~ 'Maks.+'; // RESULT false

set search_path = "postgres",coupon_system;
create or replace function loginValidator(nickname varchar, email varchar, u_password varchar) returns boolean as $$
    DECLARE
        checked boolean := false; n_regex varchar; e_regex varchar; p_regex varchar;
    BEGIN 

      select nickname_r , email_r, password_r into n_regex, e_regex, p_regex from regex;
      IF n_regex ~ nickname AND e_regex ~ email AND p_regex ~ u_password 
      THEN checked := true; 
      END IF;

     return checked;
    END;
$$ language plpgsql;

select loginValidator('Maks.+','[email protected]','+_Maks1988');

select nickname_r from regex;

select '([0-9a-zA-Z\.\-\_\=\+\@]{2,15})' ~ 'Maks.+'; // RESULT false

klin · Accepted Answer · 2018-10-21 16:25:27Z

1

A pattern should be on the right side of the operator:

select 'Maks.+' ~ '([0-9a-zA-Z\.\-\_\=\+\@]{2,15})'; 
-- yields true

answered Oct 21, 2018 at 16:25

klin

123k15 gold badges241 silver badges263 bronze badges

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

Collectives™ on Stack Overflow

How to compare regular expressions correctly in postgreSQL?

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