Postgres Pro
Downloads
Home   >   mailing lists

Returning only alphanumeric values from a query - Mailing list pgsql-sql

From Enrique Palacios
Subject Returning only alphanumeric values from a query
Date
Msg-id AANLkTinh3i9FF5=1+yYsACPVW_Lo2hY-8mOJabPjidXT@mail.gmail.com
Whole thread Raw
Responses Re: Returning only alphanumeric values from a query
List pgsql-sql
Tree view
HI everyone,

Im new here, this is my first mail and i would like to know how return from a query only alphanumeric values and these symbols: ().,-%
Something like:
SELECT description FROM products WHERE productid = 5

RESULT
======
X# PRODUCT %1.0/30(UN)

DESIRED RESULT
==============
X PRODUCT %1.0 30(UN)

I read some info, but it didnt worked out for me using regular expressions 

excuse my poor english
thank you very much

-- 
Enrique Palacios
RRHH - Informática
Farmacias RedFarma Calama

pgsql-sql by date:

Previous
From: Torsten Zühlsdorff
Date:
Subject: Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them
Next
From: Osvaldo Kussama
Date:
Subject: Re: Returning only alphanumeric values from a query