Using CASE-WHEN statement in PostgreSQL

postgre.sql

/** Minimal example **/
SELECT
  CASE
  WHEN 1 > 0 THEN 'one is greater than zero'
  ELSE 'something else'
END AS "ALIASED_FIELD_NAME_HERE"

/** In table example **/
SELECT
  CASE
  WHEN table_name.field_name::integer > 0 THEN 'it is more than zero'
  WHEN table_name.field_name::integer = 1 THEN 'it is single'
  ELSE 'something else'
END AS "ALIASED_FIELD_NAME_HERE"
FROM
table_name