amul sul <> writes:
> concat function and operator || have different behaviour, if any input is 

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

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to