Hi Reeza and PGStats, the thread has been solved thanks to PGStat's original post. I mis-coded my array earlier, hence it didn't work. I realised my error and found that PGStat's solution worked perfectly. Thanks for your help!!
... View more
Thanks for the help! I tried both methods and they both worked For my purposes i am using a proc sql, but E.G. task solution is pretty neat too
... View more