QueryLambda.R

emp = new.tableRef("emp", "PostgreSQL", "postgre.config", "public")
minsalary = 2500
q = select(function (x) {
             res = new.env()
             res$empno = x$empno
             res$ename = x$ename
             res$salary = (function (dol) dol * 89 / 100)(x$sal)
             res },
    where(function (x) x$sal >= minsalary,
    from(emp)))
results = query.force(q)
print(results)