struct_gather_spread.sql 946 B

1234567891011121314151617181920212223242526272829
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. select
  4. StructMembers(<|a:1|>),
  5. StructMembers(Just(<|a:1|>)),
  6. StructMembers(null),
  7. GatherMembers(<||>),
  8. GatherMembers(<|a:1,b:2|>),
  9. GatherMembers(Just(<|a:1,b:2|>)),
  10. GatherMembers(null),
  11. RenameMembers(<|a:1,c:2|>,[("a","b")]),
  12. RenameMembers(<|a:1,c:2|>,[("a","b"),("a","d")]),
  13. ForceRenameMembers(<|a:1,c:2|>,[("a","b")]),
  14. ForceRenameMembers(<|a:1,c:2|>,[("d","d")]),
  15. RenameMembers(Just(<|a:1,c:2|>),[("a","b")]),
  16. RenameMembers(null,[("a","b")]),
  17. SpreadMembers([("a",1)],["a","b"]),
  18. SpreadMembers([("a",1),("b",2)],["a","b"]),
  19. SpreadMembers([("a",Just(1))],["a","b"]),
  20. SpreadMembers([("a",1),("a",2)],["a","b"]),
  21. SpreadMembers([],["a","b"]),
  22. SpreadMembers(Just([("a",1)]),["a","b"]),
  23. SpreadMembers(null,["a","b"]),
  24. ForceSpreadMembers([("a",1)],["a","b"]),
  25. ForceSpreadMembers([("c",1)],["a","b"]);