Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 1 4
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Feb
9
comment How to cast an integer to a boolean in a MySQL SELECT clause?
Could it return 2 strings, instead of 0 and 1?
Feb
9
comment How to cast an integer to a boolean in a MySQL SELECT clause?
Basically what you're saying is that in a View it is impossible to have a boolean value based on a calculation?
Feb
9
comment How to cast an integer to a boolean in a MySQL SELECT clause?
The problem is that it is somehow yelded to Int, where it should at least be bit, which I could use to do the mapping. The cast function doesn't intend to do that? Sorry if the question sounds dumb, I just don't have that much of a DB knowledge.
Feb
9
comment How to cast an integer to a boolean in a MySQL SELECT clause?
if(gu.StoppingUnitEventME = ese.MonitoringElement, true, false) AS IsStopingEvent returns 0 and 1.