PivotalR (version 0.1.18.5)

Func-methods: Mathematical functions that take '>db.obj objects as the argument

Description

Functions that apply onto '>db.obj objects

Usage

# S4 method for db.obj
exp(x)
# S4 method for db.obj
abs(x)
# S4 method for db.obj
log(x, ...)
# S4 method for db.obj
log10(x)
# S4 method for db.obj
sign(x)
# S4 method for db.obj
sqrt(x)
# S4 method for db.obj
factorial(x)
# S4 method for db.obj
sin(x)
# S4 method for db.obj
cos(x)
# S4 method for db.obj
tan(x)
# S4 method for db.obj
asin(x)
# S4 method for db.obj
acos(x)
# S4 method for db.obj
atan(x)
# S4 method for db.obj,db.obj
atan2(y, x)
# S4 method for db.obj,numeric
atan2(y, x)
# S4 method for numeric,db.obj
atan2(y, x)

Arguments

x,y

'>db.obj object. The function applies to each column of the '>db.obj object. If a column is an array, then the function applies onto each element of the array. If the data type of the column makes no sense to be used in the function, then a null value is returned.

…

Extra parameters. Not implemented.

Value

'>db.Rquery object, which contains the SQL query that computes the 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)

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

x$rings <- exp(x$rings) # change the values

x$area <- log((x$length + 1) * (x$height + 1)) # 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)
# }