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