Comparison Operators for db.obj objects

Description

These binary operators perform comparison on db.obj objects

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
## S4 method for signature 'db.obj,db.obj'
e1 > e2
## S4 method for signature 'db.obj,db.obj'
e1 < e2
## S4 method for signature 'db.obj,db.obj'
e1 >= e2
## S4 method for signature 'db.obj,db.obj'
e1 <= e2
## S4 method for signature 'db.obj,db.obj'
e1 == e2
## S4 method for signature 'db.obj,db.obj'
e1 != e2
## S4 method for signature 'character,db.obj'
e1 > e2
## S4 method for signature 'character,db.obj'
e1 < e2
## S4 method for signature 'character,db.obj'
e1 >= e2
## S4 method for signature 'character,db.obj'
e1 <= e2
## S4 method for signature 'character,db.obj'
e1 == e2
## S4 method for signature 'character,db.obj'
e1 != e2
## S4 method for signature 'db.obj,character'
e1 > e2
## S4 method for signature 'db.obj,character'
e1 < e2
## S4 method for signature 'db.obj,character'
e1 >= e2
## S4 method for signature 'db.obj,character'
e1 <= e2
## S4 method for signature 'db.obj,character'
e1 == e2
## S4 method for signature 'db.obj,character'
e1 != e2
## S4 method for signature 'numeric,db.obj'
e1 > e2
## S4 method for signature 'numeric,db.obj'
e1 < e2
## S4 method for signature 'numeric,db.obj'
e1 >= e2
## S4 method for signature 'numeric,db.obj'
e1 <= e2
## S4 method for signature 'numeric,db.obj'
e1 == e2
## S4 method for signature 'numeric,db.obj'
e1 != e2
## S4 method for signature 'db.obj,numeric'
e1 > e2
## S4 method for signature 'db.obj,numeric'
e1 < e2
## S4 method for signature 'db.obj,numeric'
e1 >= e2
## S4 method for signature 'db.obj,numeric'
e1 <= e2
## S4 method for signature 'db.obj,numeric'
e1 == e2
## S4 method for signature 'db.obj,numeric'
e1 != e2
## S4 method for signature 'db.obj,logical'
e1 == e2
## S4 method for signature 'logical,db.obj'
e1 == e2
## S4 method for signature 'db.obj,logical'
e1 != e2
## S4 method for signature 'logical,db.obj'
e1 != e2
## S4 method for signature 'character,db.obj'
grepl(pattern, x, ignore.case = FALSE, perl = FALSE, fixed = FALSE, useBytes = FALSE)

Arguments

e1, e2

numeric, character or db.obj object.

pattern

character string containing a regular expression (or character string for 'fixed = TRUE') to be matched in the given character vector.

x

A db.obj object.

ignore.case

if 'FALSE', the pattern matching is _case sensitive_ and if 'TRUE', case is ignored during matching.

perl

logical. Should perl-compatible regexps be used? Not implemented yet.

fixed

logical. If 'TRUE', 'pattern' is a string to be matched as is. Overrides all conflicting arguments.

useBytes

logical. Not implemented yet.

Value

db.Rquery object, which contains the SQL query that computes the comparison operations.

Note

A meaningful expression is generated only when the .col.data_type is "character" or "numeric", otherwise a "NULL" value is generated.

Author(s)

Author: Predictive Analytics Team at Pivotal Inc.

Maintainer: Frank McQuillan, Pivotal Inc. fmcquillan@pivotal.io

See Also

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

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
## Not run: 
## get the help for a method
## help(">,db.obj,db.obj-method")


## 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)

lk(x[x$length > 10,])

db.disconnect(cid, verbose = FALSE)

## End(Not run)

Questions? Problems? Suggestions? or email at ian@mutexlabs.com.

Please suggest features or report bugs with the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.