On: Postgres Demystified

[jeffdavis]

I can see most of those being useful so that you can easily extract components. For instance, from a URL you might want to extract the URI; or from a phone number you might want to extract the country code.

If done right, I can see those being useful. I agree that it can be overdone, though.