Hello again > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Charles > Clavadetscher > Sent: Sonntag, 28. Februar 2016 11:24 > To: 'Sterpu Victor' <victor@xxxxxxxx>; 'PostgreSQL General' <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: CONCAT returns null > > 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? Forget it. Should not depend on that. If you have any null entry it will be added in the array as NULL. Bye Charles -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
