Received: from fw.wintelcom.net (root@ns1.wintelcom.net [209.1.153.20]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA75055 for ; Mon, 25 Oct 1999 10:25:26 -0400 (EDT) (envelope-from kc@wintelcom.net) Received: from dev01 (a204b210n104client163.hawaii.rr.com [204.210.104.163]) by fw.wintelcom.net (8.9.3/8.9.3) with SMTP id HAA29540 for ; Mon, 25 Oct 1999 07:47:33 -0700 (PDT) Message-ID: <016e01bf1ef5$40ad8e40$a368d2cc@hawaii.rr.com> From: "KC" To: Subject: modifying query results with a regex? Date: Mon, 25 Oct 1999 04:28:46 -1000 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_016B_01BF1EA1.6D3EBFA0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_016B_01BF1EA1.6D3EBFA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_016B_01BF1EA1.6D3EBFA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Does there currently exist in Postgres' = SQL a way=20 to modify the results of a query using regex, without writing a = custom=20 function?
 
I'd like to grab about 1000+ columns = and apply a=20 regex 'mask' to them then categorize them based on the new values and = return the=20 result.
 
Thanks in advance :)
 
-KC
------=_NextPart_000_016B_01BF1EA1.6D3EBFA0--