Thread: text -> extracted list of words

text -> extracted list of words

From
Nabil Sayegh
Date:
Hi all,

I'm looking for a way to extract all words out of a text-field.
Delimiter: all except alphanumeric + dash + underscore

e.g.

SELECT extr('Hello World. This is a foo_bar test','-_a-zA-Z0-9');
'Hello'
'World'
'This'
'is'
'a'
'foo_bar'
'test'
7 rows

Of course I could do this in the app but in the db it would be much handier.
Is there already such a function ?

TIA
--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de