PivotalR (version 0.1.18.3.1)

Arith-methods: Arithmetic Operators for '>db.obj objects

Description

These binary operators perform arithmetic on '>db.obj objects

Usage

# S4 method for db.obj,db.obj
+(e1, e2)
# S4 method for db.obj,db.obj
-(e1, e2)
# S4 method for db.obj,ANY
-(e1, e2)
# S4 method for db.obj,db.obj
*(e1, e2)
# S4 method for db.obj,db.obj
/(e1, e2)
# S4 method for db.obj,db.obj
%%(e1, e2)
# S4 method for db.obj,db.obj
%/%(e1, e2)
# S4 method for db.obj,db.obj
^(e1, e2)
# S4 method for numeric,db.obj
+(e1, e2)
# S4 method for character,db.obj
+(e1, e2)
# S4 method for numeric,db.obj
-(e1, e2)
# S4 method for character,db.obj
-(e1, e2)
# S4 method for numeric,db.obj
*(e1, e2)
# S4 method for numeric,db.obj
/(e1, e2)
# S4 method for numeric,db.obj
%%(e1, e2)
# S4 method for numeric,db.obj
%/%(e1, e2)
# S4 method for numeric,db.obj
^(e1, e2)
# S4 method for db.obj,numeric
+(e1, e2)
# S4 method for db.obj,character
+(e1, e2)
# S4 method for db.obj,numeric
-(e1, e2)
# S4 method for db.obj,character
-(e1, e2)
# S4 method for db.obj,numeric
*(e1, e2)
# S4 method for db.obj,numeric
/(e1, e2)
# S4 method for db.obj,numeric
%%(e1, e2)
# S4 method for db.obj,numeric
%/%(e1, e2)
# S4 method for db.obj,numeric
^(e1, e2)

Arguments

e1, e2

numeric or '>db.obj object.

Value

'>db.Rquery object, which contains the SQL query that computes the arithmetic operations.

See Also

'>db.Rquery contains a SQL query that does the operations.

Examples

# NOT RUN {
## get the help for a method
## help("+,db.obj,db.obj-method")

<!-- %% @test .port Database port number -->
<!-- %% @test .dbname Database name -->
## set up the database connection
## Assume that .port is port number and .dbname is the database name
cid <- db.connect(port = .port, dbname = .dbname, verbose = FALSE)

## ----------------------------------------------------------------------

## create a table from the example data.frame "abalone"
delete("abalone", conn.id = cid)
x <- as.db.data.frame(abalone, "abalone", conn.id = cid, verbose = FALSE)

x$rings <- (x$rings + 2.3) * 3 # change the values

x$area <- x$length * x$height # add a new column

lk(x$area, 10) # view the actual values computed in database

fit <- madlib.lm(rings ~ area, data = x)

## ----------------------------------------------------------------------

db.disconnect(cid, verbose = FALSE)
# }