charmi
Reputation: 307
pattern matching in postgresql
I need to substring "test" from my variable "5.myname (test)" in postgresql I am able to extract number[i.e 5] and text [i.e myname] from above string but unable to extract test. can anyone please suggest pattern to extract test from above string.
Upvotes: 0
Views: 42
Answers (1)
Related Questions
- Check if variable contains x in PostgreSQL function
- Postgres function to return regexp_matches result
- Why does Postgresql function not work as expected
- Pattern matching in Postgres SELECT query
- regex in postgresql function
- Error: column does not exist in PostgreSQL
- String Matching Pattern in postgresql
- Postgres Function Parameter in RegEx Where Clause
- regexp_matches returns NULL inside plpgsql function
- simple parameter substitution in regexp_matches postgreSQL function