constant_fold_minmax.sql 768 B

12345678910111213141516171819
  1. /* postgres can not */
  2. SELECT
  3. MIN_OF(50ut, -255ut, 5ut, 15ut) AS MinByte,
  4. MAX_OF(50ut, -255ut, 5ut, 15ut) AS MaxByte,
  5. MIN_OF(300000, -600000, 4) AS MinInt32,
  6. MAX_OF(300000, -600000, 4) AS MaxInt32,
  7. MIN_OF(300000u, 600u, -4000000000u) AS MinUInt32,
  8. MAX_OF(300000u, 600u, -4000000000u) AS MaxUInt32,
  9. MIN_OF(80l, 5000000000l, 90l, -6000000000l) AS MinInt64,
  10. MAX_OF(80l, 5000000000l, 90l, -6000000000l) AS MaxInt64,
  11. MIN_OF(80ul, -5000000000ul, 90ul, 6000000000ul) AS MinUInt64,
  12. MAX_OF(80ul, -5000000000ul, 90ul, 6000000000ul) AS MaxUInt64,
  13. MIN_OF(50ut, -10, 56l, 17u, 78ul) AS MinMixed1,
  14. MAX_OF(50ut, -10, 56l, 17u, 78ul) AS MaxMixed1,
  15. MIN_OF(50ut, 30, 40) AS MinMixed2,
  16. MAX_OF(50ut, 30, 40) AS MaxMixed2,
  17. MIN_OF(1) AS MinSingle,
  18. MAX_OF(-1) AS MaxSingle;