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