Re: [sqlite] Can someone explain these outputs for me?

2017-11-11 Thread Igor Tandetnik
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

[sqlite] Can someone explain these outputs for me?

2017-11-11 Thread Balaji Ramanathan
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