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