[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

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