How to apply a regular expression to a select statement - Mailing list pgsql-novice

From JORGE MALDONADO
Subject How to apply a regular expression to a select statement
Date
Msg-id CAAY=A7-N1qJhx6hRpsneFUjdKdxXAC8Dpb0_it1rn12_yieesQ@mail.gmail.com
Whole thread Raw
Responses Re: How to apply a regular expression to a select statement  ("ktm@rice.edu" <ktm@rice.edu>)
List pgsql-novice
Please consider the following situation.

SELECT tar_clave, tar_nombre, tar_dir, tar_vdir FROM cat_tipos_artista

The field "tar_dir" was URL encoded before inserting the record into the database. What I need is to URL decode it right within the SELECT statement and I think that, maybe, this can be achieved by applying a regular expression in such a statement. I will very much appreciate if someone tells me if this is possible and how.

Respectfully,
Jorge Maldonado

pgsql-novice by date:

Previous
From: "Della-Croce, Gregory"
Date:
Subject: A very simple question about rollback/commit
Next
From: "ktm@rice.edu"
Date:
Subject: Re: How to apply a regular expression to a select statement