We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Sorry, there was a logical error there, which I found by adding more examples. This now seems to work fine though, but it still doesn't like it:
select
case
when A>=B+C or B>A+C or C>=A+B then 'Not a triangle'
when A=B and B=C then 'Equilateral'
when (A=B and B!=C) or (A=C and C!=B) or (B=C and C!=A) then 'Isosceles'
when A!=B and B!=C and A!=C then 'Scalene'
else 'Balls Up'
end as Type
from triangles;
Type of Triangle
You are viewing a single comment's thread. Return to all comments →
Sorry, there was a logical error there, which I found by adding more examples. This now seems to work fine though, but it still doesn't like it:
select case when A>=B+C or B>A+C or C>=A+B then 'Not a triangle' when A=B and B=C then 'Equilateral' when (A=B and B!=C) or (A=C and C!=B) or (B=C and C!=A) then 'Isosceles' when A!=B and B!=C and A!=C then 'Scalene' else 'Balls Up' end as Type from triangles;