amul sul <sul_amul(at)yahoo(dot)co(dot)in> writes:
> concat function and operator || have different behaviour, if any input is NULL.
The behavior of || is specified by the SQL standard, and it says (SQL99
6.27 <string value expression> general rule 2a):
a) If either S1 or S2 is the null value, then the result of the
<concatenation> is the null value.
So no, we're not changing it to be more like concat().
regards, tom lane