Thread: modifying query results with a regex?

modifying query results with a regex?

From
"KC"
Date:
Does there currently exist in Postgres' SQL a way to modify the results of a query using regex, without writing a custom function?
 
I'd like to grab about 1000+ columns and apply a regex 'mask' to them then categorize them based on the new values and return the result.
 
Thanks in advance :)
 
-KC