Re: [HACKERS] empty concatenate

Поиск
Список
Период
Сортировка
От D'Arcy" "J.M." Cain
Тема Re: [HACKERS] empty concatenate
Дата
Msg-id m121CKg-0000daC@druid.net
обсуждение исходный текст
Ответ на Re: [HACKERS] empty concatenate  (Karel Zak - Zakkr <zakkr@zf.jcu.cz>)
Ответы Re: [HACKERS] empty concatenate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Thus spake Karel Zak - Zakkr
>  I not agree with this concept:-). 

You are not alone.

> (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...  

This is the issue no matter which side of the debate you are on.  I
think everyone agrees that either the function should not be called
or else the result should be used if it is.  CPU is a terrible thing
to waste.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Adriaan Joubert
Дата:
Сообщение: Index corruption
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: [HACKERS] --with-mb=SQL_ASCII for 6.5.3 RPMs.