Re: [HACKERS] empty concatenate

Karel Zak <zakkr@zf.jcu.cz>

From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: sszabo@bigpanda.com
Cc: pgsql-hackers@postgresql.org
Date: 1999-12-23T17:01:33Z
Lists: pgsql-hackers
> 
> >
> >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. 
> I believe this is a known issue that's being looked at right now.

 I not agree with this concept:-). 

(My problem is not write query, I know SQL and coalesce()...etc. I want 
good understand current implementation.)

! Why is textcat() (and other) function called if result from this 
function is ignored, it is bad spending (my CPU is not boredom). See 
my 'C' example in my first letter...  

						Karel