Is the CASE statement unnecessary?

[eliasmalik]

In this query:

pulp-faction/src/controllers/queries.js

Line 4 in 7a8d71c

db.query('SELECT CASE WHEN EXISTS(SELECT gitterhandle FROM users WHERE gitterhandle = $1) THEN CAST (true AS BOOLEAN) ELSE CAST (false AS BOOLEAN) END', [gitterhandle]);

You're using a CASE statement to return a boolean, when your condition already returns a boolean. This is analogous to:

if (x == y) {
  return true;
} else {
  return false;
}

Simpler would be return x == y;. In the case of your query, you can get rid of the CASE statement and just use EXISTS directly.