GREATEST or LEAST expression must have a data type

  Explanation:  The GREATEST and LEAST expression does not have a
  data type because all of the results are NULL or of an unknown
  type.

  User Action:  Assign a data type to at least one result.