On Wed, Oct 17, 2007 at 01:00:48PM -0500, Josh Trutwin wrote: > Works like a champ on 8.1. > > Thanks! That's OK, it was a good learning experience. > Did you see David Fetter's reply to the original post? He has > an interesting alternative. I did, it's much more elegant. I've never seen generate_series used like that, it's a very nice way of doing things. If your arrays are ever more than a few elements long his is probably going to be much faster. Generally for less than 6 or 7 elements it's better doing the naive thing, not sure if that applies here though. Sam ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/