ydb/yql/essentials/tests/sql/suites/compute_range/pg_compare.sql

/* syntax version 1 */
/* postgres can not */
/* dq can not */
/* dqfile can not */
/* yt can not */
pragma warning("disable", "4510");
pragma warning("disable", "1108");

-- a > 2
select YQL::RangeComputeFor(
    Struct<a:PgInt4,b:PgText>,
    ($row) -> (FromPg(PgOp(">", $row.a, 2p)) ?? false),
    AsTuple(AsAtom("a"))
);

-- a >= 2
select YQL::RangeComputeFor(
    Struct<a:PgInt4,b:PgText>,
    ($row) -> (($row.a >= 2p) ?? false),
    AsTuple(AsAtom("a"))
);

-- b < 2
select YQL::RangeComputeFor(
    Struct<a:PgInt4,b:PgText>,
    ($row) -> (('2'p > $row.b) ?? false),
    AsTuple(AsAtom("b"))
);

-- b <= 2
select YQL::RangeComputeFor(
    Struct<a:PgInt4,b:PgText>,
    ($row) -> (FromPg(PgOp(">=", '2'p, $row.b)) ?? false),
    AsTuple(AsAtom("b"))
);