Hello, I have a feature request.
In SQLite when strings are concatenated (with ||) and one of them is null, the result will be null. This is not a required behaviour (not intuitive) and most users tend to add *ifnull(X, '')* to get proper results. This slows down the whole operation, when we have lots of records in the database. Would it be hard to add both: compile time option (in C source) and pragma function to make concat yeld different results? In MS database there is *CONCAT_NULL_YIELDS_NULL* setting which does exacly what it states. Why there's no such functionality in SQLite? Moreover there also should be function called *concat(...)* which would take multiple arguments instead of using '||' operator. Best regards, Marcel Wesołowski _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
