[SQL] Array iterator

2009-01-27 Thread Raj Mathur 
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 Mathurr...@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

Re: [SQL] Array iterator

2009-01-27 Thread Achilleas Mantzios 
Στις Tuesday 27 January 2009 14:40:29 ο/η Raj Mathur έγραψε:
> select regexp_split_to_array('string with tokens', '[^A-Za-z0-9]');
> 
maybe
select regexp_split_to_table('string with tokens', '[^A-Za-z0-9]');
would help?
-- 
Achilleas Mantzios

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql