Stefan Berglund <stefan_berglund@xxxxxxx> writes: > Below is a small test case that illustrates what I'm attempting which is > to provide a comma separated list of numbers to a procedure which > subsequently uses this list in a join with another table. > My questions are is this a set based solution and is this the best > approach in terms of using the data types and methods afforded by > PostgreSQL? I'm mostly inquiring about the double FOR loop which just > doesn't feel right to me ... It looks pretty ugly to me too, but you haven't explained your problem clearly enough for anyone to be able to recommend a better solution path. Why do you feel you need to do this? What is the context? regards, tom lane
