PivotalR (version 0.1.18.5)

Logical-methods: Logical operations for '>db.obj objects

Description

These binary operators perform logical operations on '>db.obj objects

Usage

## S4 method for signature 'db.obj' 
# S4 method for db.obj
!(x) 
# S4 method for db.obj,db.obj
&(e1, e2) 
# S4 method for db.obj,db.obj
|(e1, e2) 
# S4 method for db.obj,logical
&(e1, e2) 
# S4 method for db.obj,logical
|(e1, e2) 
# S4 method for logical,db.obj
&(e1, e2) 
# S4 method for logical,db.obj
|(e1, e2)

Arguments

e1, e2

logical or '>db.obj object.

x

'>db.obj object.

Value

'>db.Rquery object, which contains the SQL query that computes the logical 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"
x <- as.db.data.frame(abalone, conn.id = cid, verbose = FALSE)

lk(x$rings[x$length > 10 & x$height < 2,])

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