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 r...@kandalaya.org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
PsyTrance & Chill: http://schizoid.in/ || It is the mind that moves
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
