code:

select case when 1>2 then 1 else 2 end;
  

code:

    IF prof_start > ts THEN
      ts = prof_start;
    END IF;
    IF prof_end < te THEN
      te = prof_end;
    END IF;

  

Quote:

---

9.13.4. GREATEST and LEAST

GREATEST(value [, ...])

LEAST(value [, ...])

The GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details). NULL values in the list are ignored. The result will be NULL only if all the expressions evaluate to NULL.

Note that GREATEST and LEAST are not in the SQL standard, but are a common extension.

---