amul sul <[email protected]> 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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
