mercredi 26 avril 2017

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.

Aucun commentaire:

Enregistrer un commentaire