Postgres Pro
Downloads
Home   >   mailing lists

modifying query results with a regex? - Mailing list pgsql-sql

From KC
Subject modifying query results with a regex?
Date
Msg-id 016e01bf1ef5$40ad8e40$a368d2cc@hawaii.rr.com
Whole thread Raw
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Postgres
Date:
Subject: Vacuum takes more than 1 hr
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Vacuum takes more than 1 hr