Hello Just a short question to that. > CONCAT(f.nrfo, '/', TO_CHAR(fd1.validfrom, 'YYYY-MM-DD'), f2.nrfo, TO_CHAR(fd7.validfrom, 'YYYY-MM-DD'), > DATE(fd5.validto)-DATE(fd1.validfrom)) > that works fine but when I change to this(I added a ' with '): > ARRAY_AGG(CONCAT(f.nrfo, '/', TO_CHAR(fd1.validfrom, 'YYYY-MM-DD'), ' with ', f2.nrfo, TO_CHAR(fd7.validfrom, 'YYYY- > MM-DD'), DATE(fd5.validto)-DATE(fd1.validfrom))) AS temp, > then concat returns NULL. > Why? I tried to add ' with '::VARCHAR and ' with '::TEXT but the result is still NULL. Do you get NULL also if you run the query without the call to array_agg(), i.e. for all entries in your table? Bye Charles -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
