Qore SqlUtil Module Reference  1.3.3
 All Classes Namespaces Functions Variables Groups Pages
SQL Column Operators

Variables

const SqlUtil::COP_APPEND = "append"
 to append a string to a column on output More...
 
const SqlUtil::COP_AS = "as"
 to rename a column on output More...
 
const SqlUtil::COP_AVG = "avg"
 to return the average value More...
 
const SqlUtil::COP_CAST = "cast"
 to convert column value into another datatype More...
 
const SqlUtil::COP_COALESCE = "coalesce"
 to return the first non-null argument in the list More...
 
const SqlUtil::COP_COUNT = "count"
 to return the row count More...
 
const SqlUtil::COP_DISTINCT = "distinct"
 to return distinct values More...
 
const SqlUtil::COP_DIVIDE = "divide"
 the SQL "divide" operator More...
 
const SqlUtil::COP_LENGTH = "length"
 to get the length of a text field More...
 
const SqlUtil::COP_LOWER = "lower"
 to return column value in lower case More...
 
const SqlUtil::COP_MAX = "max"
 to return the maximum value More...
 
const SqlUtil::COP_MIN = "min"
 to return the minimum value More...
 
const SqlUtil::COP_MINUS = "minus"
 the SQL "minus" operator More...
 
const SqlUtil::COP_MULTIPLY = "multiply"
 the SQL "multiply" operator More...
 
const SqlUtil::COP_OVER = "over"
 the SQL "over" clause More...
 
const SqlUtil::COP_PLUS = "plus"
 the SQL "plus" operator More...
 
const SqlUtil::COP_PREPEND = "prepend"
 to prepend a string to a column on output More...
 
const SqlUtil::COP_SEQ = "seq"
 to return the next value of a sequence More...
 
const SqlUtil::COP_SEQ_CURRVAL = "seq_currval"
 to return the last value of a sequence issued in the same session More...
 
const SqlUtil::COP_SUBSTR = "substr"
 to extract a substring from a column More...
 
const SqlUtil::COP_SUM = "sum"
 to return the sum value More...
 
const SqlUtil::COP_UPPER = "upper"
 to return column value in upper case More...
 
const SqlUtil::COP_VALUE = "value"
 to append a constant value (SQL Literal) to use as an output column value More...
 
const SqlUtil::COP_YEAR = "year"
 to return a date value with year information only More...
 
const SqlUtil::COP_YEAR_DAY = "year_day"
 to return a date value with year to day information More...
 
const SqlUtil::COP_YEAR_HOUR = "year_hour"
 to return a date value with year to hextern information More...
 
const SqlUtil::COP_YEAR_MONTH = "year_month"
 to return a date value with year to month information More...
 
const SqlUtil::DefaultCopMap
 a hash of default column operator descriptions
 

Detailed Description

These are the operators that can be used in the "columns" argument for select statements

Variable Documentation

const SqlUtil::COP_APPEND = "append"

to append a string to a column on output

See Also
cop_append()
const SqlUtil::COP_AS = "as"

to rename a column on output

See Also
cop_as()
const SqlUtil::COP_AVG = "avg"

to return the average value

See Also
cop_avg
const SqlUtil::COP_CAST = "cast"

to convert column value into another datatype

See Also
cop_cast()
const SqlUtil::COP_COALESCE = "coalesce"

to return the first non-null argument in the list

See Also
cop_coalesce()
const SqlUtil::COP_COUNT = "count"

to return the row count

See Also
cop_count
const SqlUtil::COP_DISTINCT = "distinct"

to return distinct values

See Also
cop_distinct
const SqlUtil::COP_DIVIDE = "divide"

the SQL "divide" operator

See Also
cop_divide()
const SqlUtil::COP_LENGTH = "length"

to get the length of a text field

See Also
cop_length()
Since
SqlUtil 1.3.1
const SqlUtil::COP_LOWER = "lower"

to return column value in lower case

See Also
cop_lower()
const SqlUtil::COP_MAX = "max"

to return the maximum value

See Also
cop_max
const SqlUtil::COP_MIN = "min"

to return the minimum value

See Also
cop_min
const SqlUtil::COP_MINUS = "minus"

the SQL "minus" operator

See Also
cop_minus()
const SqlUtil::COP_MULTIPLY = "multiply"

the SQL "multiply" operator

See Also
cop_multiply()
const SqlUtil::COP_OVER = "over"

the SQL "over" clause

See Also
cop_over()
const SqlUtil::COP_PLUS = "plus"

the SQL "plus" operator

See Also
cop_plus()
const SqlUtil::COP_PREPEND = "prepend"

to prepend a string to a column on output

See Also
cop_prepend()
const SqlUtil::COP_SEQ = "seq"

to return the next value of a sequence

See Also
cop_seq()
const SqlUtil::COP_SEQ_CURRVAL = "seq_currval"

to return the last value of a sequence issued in the same session

See Also
cop_seq_currval()
const SqlUtil::COP_SUBSTR = "substr"

to extract a substring from a column

See Also
cop_substr()
const SqlUtil::COP_SUM = "sum"

to return the sum value

See Also
cop_sum
const SqlUtil::COP_UPPER = "upper"

to return column value in upper case

See Also
cop_upper()
const SqlUtil::COP_VALUE = "value"

to append a constant value (SQL Literal) to use as an output column value

See Also
cop_value()
const SqlUtil::COP_YEAR = "year"

to return a date value with year information only

See Also
cop_year()
const SqlUtil::COP_YEAR_DAY = "year_day"

to return a date value with year to day information

See Also
cop_year_day()
const SqlUtil::COP_YEAR_HOUR = "year_hour"

to return a date value with year to hextern information

See Also
cop_year_hour()
const SqlUtil::COP_YEAR_MONTH = "year_month"

to return a date value with year to month information

See Also
cop_year_month()