pg_exists.sql 420 B

1234567891011121314151617181920
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. /* dq can not */
  4. /* dqfile can not */
  5. /* yt can not */
  6. pragma warning("disable", "4510");
  7. pragma warning("disable", "1108");
  8. select YQL::RangeComputeFor(
  9. Struct<a:PgFloat8,b:PgText>,
  10. ($row) -> ($row.a is not null),
  11. AsTuple(AsAtom("a"))
  12. );
  13. select YQL::RangeComputeFor(
  14. Struct<a:PgInt4,b:PgText>,
  15. ($row) -> ($row.b is null),
  16. AsTuple(AsAtom("b"))
  17. );