Better VALUES() emulation in Informix using TABLE(MULTISET)

[lukaseder]

In Informix, we can emulate VALUES() using TABLE(SET), e.g.

-- Single column
SELECT a, b
  FROM TABLE (MULTISET {1, 2, 3, 4}) AS t(a);

-- Multi column
SELECT a, b
  FROM TABLE (MULTISET {row(1, 1), row(2, 1), row(3, 2), row(4, 2)}) AS t(a, b);

---

See also: https://stackoverflow.com/a/43178184/521799