On 11/11/2017 8:55 PM, Balaji Ramanathan wrote:
3.When there is a mathematical expression after the string, I get a 0.
My string is nowhere to be seen in the output
SQLite> select '- '||cast(-1.5 as integer)*-1
0
|| has the highest precedence. Your expression is interpreted as ( '-
'||ca
I am not sure what exactly is going on here. When an expression starts
with a string and I try to append the results of a mathematical operation
to it, sometimes it works, sometimes, it doesn't, and I can't find the
pattern behind what works and what doesn't.
1.Simple mathematical expression
2 matches
Mail list logo