stroncococcus wrote: > Ok, solved the problem with COALESCE. Hm, I not really solved it ... just solved it for text columns, but not for integer arrays. I can use this for text COALESCE(textcol, '') || 'str ' but how do I use this for integers? Is there a way to create an empty integer array and do such a thing ... COALESCE(intarraycol, *empty int array*) || 5
