in_ansi_variant.sql 689 B

12345678910111213141516171819202122232425
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. PRAGMA AnsiInForEmptyOrNullableItemsCollections;
  4. Select Enum("foo",Enum<"foo","bar">) in (
  5. AsEnum("foo")
  6. ),
  7. Enum("foo",Enum<"foo","bar">) in (
  8. AsEnum("bar")
  9. ),
  10. Enum("foo",Enum<"foo","bar">) in (
  11. AsEnum("foo"),
  12. AsEnum("bar")
  13. ),
  14. Enum("foo",Enum<"foo","bar">) in (
  15. AsEnum("bar"),
  16. AsEnum("baz")
  17. ),
  18. Enum("foo",Enum<"foo","bar">) in [
  19. AsEnum("foo"),
  20. AsEnum("bar")
  21. ],
  22. Enum("foo",Enum<"foo","bar">) in {
  23. AsEnum("bar"),
  24. AsEnum("baz")
  25. };