Hi,
Is there any way to apply a built-in function to all elements of an
array (and get an array as result) without using a procedural language?
Specifically, I'm looking at being able to take a string, tokenise it
into an array and apply soundex to each of the tokens (not particularly
efficient or effective, but serves this specific purpose). Have got as
far as:
select regexp_split_to_array('string with tokens', '[^A-Za-z0-9]');
Can one now process the resulting array in a single shot within SQL
itself?
Regards,
-- Raju
--
Raj Mathur raju@kandalaya.org http://kandalaya.org/ GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968
D0EFCC68 D17F
PsyTrance & Chill: http://schizoid.in/ || It is the mind that moves