join_key_cmp_udf.sql 217 B

1234567891011
  1. PRAGMA DisableSimpleColumns;
  2. /* postgres can not */
  3. USE plato;
  4. --INSERT INTO Output
  5. SELECT
  6. ib.*
  7. FROM Input as ia
  8. JOIN Input as ib
  9. ON Unicode::ToUpper(CAST(ia.key AS Utf8)) == ib.subkey
  10. ORDER BY ib.key, ib.subkey