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

Reply via email to