Thread: Array iterator

Array iterator

From

Raj Mathur

Date:

27 January 2009, 11:40:58

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

Re: Array iterator

From

Achilleas Mantzios

Date:

27 January 2009, 13:08:19

Στις 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

Re: Array iterator

From

Raj Mathur

Date:

06 February 2009, 02:34:29

On Tuesday 27 Jan 2009, Achilleas Mantzios wrote:
> Στις 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?

That did the job, thanks!

-- 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