Postgres sql with regex expression

Question

Trying to run sql : https://dbfiddle.uk/VlKz_7fg When I am running sql on fiddle its working fine, however when I am trying to run the same on my database it is throwing - ERROR: invalid regular expression: invalid character class

Can anyone please help how to resolve it..

Your fiddle uses ver 16 of the DB. If you lower it down you will get this error: dbfiddle.uk/iFUUelgr Check your version and what regex it supports. — PM 77-1
– PM 77-1, Commented Apr 5, 2024 at 18:53
@PM77-1 : Yes,its version 9.4.26.Can you pls help what do I need to change in regex to support this one? — Ram
– Ram, Commented Apr 5, 2024 at 19:07

PM 77-1 · Accepted Answer · 2024-04-05 20:44:56Z

-1

You use the following character classes:

alpha
word

In the listing of available classes for ver. 9.4 I see alpha but not word. See section 9.7.3.2. in https://www.postgresql.org/docs/9.4/functions-matching.html

[[:word:]]
Matches letters, numbers and underscores. Equivalent to \w or [a-zA-Z0-9_].

So replace [[:word:]] with \w.

See 9.4 based Fiddle

answered Apr 5, 2024 at 20:44

PM 77-1

13.4k21 gold badges73 silver badges118 bronze badges

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

Collectives™ on Stack Overflow

Postgres sql with regex expression

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