compare_tuple.sql 371 B

1234567891011121314
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. select
  4. key,
  5. min(AsTuple(subkey, value)) as min,
  6. max(AsTuple(subkey, value)) as max
  7. from (
  8. select
  9. key,
  10. (case when length(subkey) != 0 then subkey else null end) as subkey,
  11. (case when length(value) != 0 then value else null end) as value
  12. from plato.Input
  13. ) group by key
  14. order by key