modifying query results with a regex?

From: "KC" <kc(at)wintelcom(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: modifying query results with a regex?
Date: 1999-10-25 14:28:46
Message-ID: 016e01bf1ef5$40ad8e40$a368d2cc@hawaii.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-10-25 14:45:30 Re: [SQL] Vacuum takes more than 1 hr
Previous Message Postgres 1999-10-25 10:52:18 Vacuum takes more than 1 hr