If anything I would prefer it to return an empty string as returning Null could mess up the detection of the column data type.
RBS On Tue, Feb 27, 2018 at 7:46 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 27 Feb 2018, at 7:01am, Hick Gunter <h...@scigames.at> wrote: > > > What should substr('abcd',0,-2) return? 'cd' or just 'd'? Or maybe just > an empty string? > > NULL > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users