Jim Nasby <Jim.Nasby@xxxxxxxxxxxxxx> writes: > BTW, if you want to simply apply a function to all elements in an array > there is an internal C function array_map that can do it. There's no SQL > interface to it, but it shouldn't be hard to add one. That wouldn't be useful for the example given originally, since it iterates over just one array not two arrays in parallel. But you could imagine writing something similar that would iterate over two arrays and call a two-argument function. Whether it's worth a SQL interface is debatable though. Whatever efficiency you might gain from using this would probably be eaten by the overhead of calling a SQL or PL function for each pair of array elements. You'd probably end up in the same ballpark performance-wise as the UNNEST solution given earlier. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
