Transfer regex from Java to PostgreSQL

Question

How can I transfer the following regex from Java to PostgreSQL syntax:

Pattern.compile("(?imu)(P\\W*Ř\\W*E\\W*D\\W*V\\W*O\\W*L\\W*Á\\W*N\\W*Í)"));

I have tried:

select regexp_matches('P Ř E D V O L Á N Í','(?imu)(P\\W*Ř\\W*E\\W*D\\W*V\\W*O\\W*L\\W*Á\\W*N\\W*Í)')

But got ERROR: invalid regular expression: invalid embedded option

fvu · Accepted Answer · 2013-04-16 14:15:30Z

1

Postgres uses POSIX RE's that don't support the u (Enable Unicode-aware case folding) flag in (?imu)

answered Apr 16, 2013 at 14:15

fvu

33.1k6 gold badges64 silver badges84 bronze badges

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

1 Comment

Tomas Greif Over a year ago

Thank you. I've ended up with

select regexp_matches(upper('PřED vo lÁn í'),'(P[[:space:]]*Ř[[:space:]]*E[[:space:]]*D[[:space:]]*V[[:space:]]*O[[:space:]]*L[[:space:]]*Á[[:space:]]*N[[:space:]]*Í)')

Not the same, but seems to work.

Collectives™ on Stack Overflow

Transfer regex from Java to PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related