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 <[email protected]> wrote: > > > On 27 Feb 2018, at 7:01am, Hick Gunter <[email protected]> wrote: > > > What should substr('abcd',0,-2) return? 'cd' or just 'd'? Or maybe just > an empty string? > > NULL > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
