On Mon, Feb 26, 2018 at 12:33:29AM -0500, Igor Tandetnik wrote: > On 2/26/2018 12:23 AM, Gary Briggs wrote: > >Evening > > > >I'm seeing a weird effect when concatenting things: > >WITH q(tape,dp) AS (SELECT '04E', 1) > > SELECT SUBSTR(tape,1,dp-1) || SUBSTR(tape,dp,1)+1 || SUBSTR(tape,dp+1) AS > > expect_14E, > > || has higher precedence than +. Your expression is an arithmetic sum of two > values: > > SUBSTR(tape,1,dp-1) || SUBSTR(tape,dp,1) -- 0 > + > 1 || SUBSTR(tape,dp+1) -- '14E', converted to integer 14
Ah, that makes sense. Thanks! Gary _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
