| From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
|---|---|
| To: | "'Sterpu Victor'" <victor(at)caido(dot)ro>, "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CONCAT returns null |
| Date: | 2016-02-28 10:24:13 |
| Message-ID: | 011e01d17212$31e3de50$95ab9af0$@swisspug.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Clavadetscher | 2016-02-28 10:30:10 | Re: CONCAT returns null |
| Previous Message | Sterpu Victor | 2016-02-28 10:02:47 | CONCAT returns null |