how to write function in postgres which take these args (THOMAS,RANJAN,JDJDJDJ,OOOO','1,2,3') and give 'TxxxAS,RANJAN,JDJDJDJ,OOOO' as result - PeakU

0

253

Visualizações

how to write function in postgres which take these args (THOMAS,RANJAN,JDJDJDJ,OOOO','1,2,3') and give 'TxxxAS,RANJAN,JDJDJDJ,OOOO' as result

How to write a mask function in PostgreSQL which will take a given string and replace the given positions.

I pass ('THOMAS,RANJAN,JDJDJDJ,OOOO','1,2,3') it should result 'TxxxAS,RANJAN,JDJDJDJ,OOOO'

Here '1,2,3' are the positions I want to replace with x

over 4 years ago · Santiago Trujillo

Responde à pergunta

Encontrar trabalhos remotos