Re: [SQL] Array iterator

2009-02-05 Thread Raj Mathur
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, t

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

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