Revision 42459 trunk/org.gvsig.desktop/org.gvsig.desktop.library/org.gvsig.tools.evaluator.sqljep/src/main/java/org/gvsig/tools/evaluator/sqljep/SQLJEPEvaluator.java
| SQLJEPEvaluator.java | ||
|---|---|---|
| 195 | 195 |
"+", |
| 196 | 196 |
"Returns the sum (addition) of the left operand and" |
| 197 | 197 |
+ " the right operand.", |
| 198 |
"<Numeric_value_1> + <Numeric_value_2>",
|
|
| 198 |
" + ",
|
|
| 199 | 199 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER), |
| 200 | 200 |
new DefaultDescription( |
| 201 | 201 |
"-", |
| 202 | 202 |
"Returns the difference (subtraction) of the left operand minus" |
| 203 | 203 |
+ " the right operand. It can be used as unary operator to" |
| 204 | 204 |
+ " change the sign of the right operand.", |
| 205 |
"<Numeric_value_1> - <Numeric_value_2>",
|
|
| 205 |
" - ",
|
|
| 206 | 206 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER), |
| 207 | 207 |
new DefaultDescription( |
| 208 | 208 |
"*", |
| 209 | 209 |
"Returns the product (multiplication) of the left operand by" |
| 210 | 210 |
+ " the right operand.", |
| 211 |
"<Numeric_value_1> * <Numeric_value_2>",
|
|
| 211 |
" * ",
|
|
| 212 | 212 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER), |
| 213 | 213 |
new DefaultDescription( |
| 214 | 214 |
"/", |
| 215 | 215 |
"Returns the division of the left operand by" |
| 216 | 216 |
+ " the right operand.", |
| 217 |
"<Numeric_value_1> / <Numeric_value_2>",
|
|
| 217 |
" / ",
|
|
| 218 | 218 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER), |
| 219 | 219 |
new DefaultDescription( |
| 220 | 220 |
">", |
| 221 | 221 |
"Returns TRUE if the left operand is greater than " |
| 222 | 222 |
+ "the right operand; FALSE otherwise.", |
| 223 |
"<Left_value> > <Right_value>",
|
|
| 223 |
" > ",
|
|
| 224 | 224 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 225 | 225 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 226 | 226 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 229 | 229 |
"<", |
| 230 | 230 |
"Returns TRUE if the left operand is smaller" |
| 231 | 231 |
+ " than the right operand; FALSE otherwise.", |
| 232 |
"<Left_value> < <Right_value>",
|
|
| 232 |
" < ",
|
|
| 233 | 233 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 234 | 234 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 235 | 235 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 238 | 238 |
">=", |
| 239 | 239 |
"Returns TRUE if the left operand is greater or " |
| 240 | 240 |
+ "equal to the right operand; FALSE otherwise.", |
| 241 |
"<Left_value> >= <Right_value>",
|
|
| 241 |
" >= ",
|
|
| 242 | 242 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 243 | 243 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 244 | 244 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 247 | 247 |
"<=", |
| 248 | 248 |
"Returns TRUE if the left operand is less or " |
| 249 | 249 |
+ "equal to the right operand; FALSE otherwise.", |
| 250 |
"<Left_value> <= <Right_value>",
|
|
| 250 |
" <= ",
|
|
| 251 | 251 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 252 | 252 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 253 | 253 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| 254 | 254 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_BOOLEAN), |
| 255 | 255 |
new DefaultDescription( |
| 256 |
"==",
|
|
| 256 |
"=", |
|
| 257 | 257 |
"Returns TRUE if the left operand equals " |
| 258 | 258 |
+ "the right operand; FALSE otherwise.", |
| 259 |
"<Left_value> == <Right_value>",
|
|
| 259 |
" = ",
|
|
| 260 | 260 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 261 | 261 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 262 | 262 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 265 | 265 |
"!=", |
| 266 | 266 |
"Returns TRUE if the left operand is not equal to " |
| 267 | 267 |
+ "the right operand; FALSE otherwise.", |
| 268 |
"<Left_value> != <Right_value>",
|
|
| 268 |
" != ",
|
|
| 269 | 269 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 270 | 270 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 271 | 271 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 274 | 274 |
"And", |
| 275 | 275 |
"Returns TRUE if both operands are TRUE" |
| 276 | 276 |
+ "; FALSE otherwise.", |
| 277 |
"<Left_value> and <Right_value>",
|
|
| 277 |
" and <Right_value>", |
|
| 278 | 278 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_BOOLEAN), |
| 279 | 279 |
new DefaultDescription( |
| 280 | 280 |
"Or", |
| 281 | 281 |
"Returns TRUE if the left operand is TRUE or the " |
| 282 | 282 |
+ "right operand is TRUE; FALSE otherwise.", |
| 283 |
"<Left_value> or <Right_value>",
|
|
| 283 |
" or ",
|
|
| 284 | 284 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_BOOLEAN), |
| 285 | 285 |
new DefaultDescription( |
| 286 | 286 |
"Not", |
| 287 | 287 |
"Returns the logical inverse of the right operand: TRUE if the right " |
| 288 | 288 |
+ "operand is FALSE; FALSE otherwise.", |
| 289 |
"not <Right_value>",
|
|
| 289 |
"not ", |
|
| 290 | 290 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_BOOLEAN), |
| 291 | 291 |
new DefaultDescription( |
| 292 | 292 |
"In", |
| 293 | 293 |
"Returns TRUE if the left operand equals one of the comma-separated" |
| 294 | 294 |
+ " values; FALSE otherwise.", |
| 295 |
"<Left_value> in ( <Comma_separated_values> )",
|
|
| 295 |
" in ( <Comma_separated_values> )", |
|
| 296 | 296 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 297 | 297 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 298 | 298 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 302 | 302 |
"Returns TRUE if the left operand is greater or equal than " + |
| 303 | 303 |
"the first right operand and less or equal than the second " + |
| 304 | 304 |
"right operand; FALSE otherwise.", |
| 305 |
"<Left_value> between <Right_value_1> and <Right_value_2>",
|
|
| 305 |
" between <Right_value_1> and <Right_value_2>", |
|
| 306 | 306 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 307 | 307 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 308 | 308 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 311 | 311 |
"Like", |
| 312 | 312 |
"Returns TRUE if the left operand matches the pattern expressed " + |
| 313 | 313 |
"by the right operand; FALSE otherwise. Use '%' as wildcard.", |
| 314 |
"<Left_value> like <Right_value>",
|
|
| 314 |
" like <Right_value>", |
|
| 315 | 315 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING), |
| 316 | 316 |
new DefaultDescription( |
| 317 | 317 |
"Is Null", |
| 318 | 318 |
"Returns TRUE if the left operand has NULL value;" + |
| 319 | 319 |
" FALSE otherwise.", |
| 320 |
"<Left_value> is null",
|
|
| 320 |
" is null", |
|
| 321 | 321 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 322 | 322 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 323 | 323 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
| ... | ... | |
| 326 | 326 |
"Is Not Null", |
| 327 | 327 |
"Returns TRUE if the left operand does not have NULL value;" + |
| 328 | 328 |
" FALSE otherwise.", |
| 329 |
"<Left_value> is not null",
|
|
| 329 |
" is not null", |
|
| 330 | 330 |
EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_NUMBER |
| 331 | 331 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_STRING |
| 332 | 332 |
| EvaluatorWithDescriptions.Description.DATATYPE_CATEGORY_DATETIME |
Also available in: Unified diff