What's wrong with this regex on PostgreSQL?

Question

Can anyone explain to me why this regex select returns false in PostgreSQL:

select '354902050487064_Gismo3' ~* '\d{15}_\w+'

Tried it on several online regex testers and in matches fine.

Thanks

It returns true on my 9.4.0 (windows) and 9.3.4 (Linux) installation — user330315
– user330315, Commented Jan 16, 2015 at 12:38
Ok, got it. In SQL the \ char has to be doubbled, so this expression works: select '354902050487064_Gismo3' ~* '\\d{15}_\\w+' I'm on 6.0.7 64-bit. Thanks for the comments. — Ambran
– Ambran, Commented Jan 16, 2015 at 12:43

Toto · Accepted Answer · 2015-01-16 12:40:46Z

1

You have to escape the backslashes:

select '354902050487064_Gismo3' ~* '\\d{15}_\\w+'

answered Jan 16, 2015 at 12:40

Toto

91.7k63 gold badges97 silver badges135 bronze badges

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

1 Comment

Yes, just found that out and added at comment, but thanks anyway.