From: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] empty concatenate |
Date: | 1999-12-23 15:55:55 |
Message-ID: | Pine.LNX.3.96.991223164928.25235B-100000@ara.zf.jcu.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> NULL's can not be concatenated, but '' can. Looks fine to me:
>
> ---------------------------------------------------------------------------
>
> test=> create table ff (x text, y text);
> insCREATE
> test=> insert into ff values ('a','');
> INSERT 19082 1
> test=> insert into ff values ('b',null);
> INSERT 19083 1
> test=> select x || y from ff;
> ?column?
> ----------
> a
>
> (2 rows)
Well, but why PgSQL ignore function result if any argument is NULL. IMHO is
function's problem what return, and PgSQL must use this result.
How can user write / use function which response on NULL (as IFNULL())?
Karel
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-12-23 15:56:20 | Re: [HACKERS] empty concatenate |
Previous Message | Karel Zak - Zakkr | 1999-12-23 15:20:23 | empty concatenate |