-
Notifications
You must be signed in to change notification settings - Fork 0
Constants
Nathan Bruer edited this page Oct 10, 2015
·
3 revisions
Constants consist of strings or numbers in their literal form. If encased in " (double) or ' (single) quotes it will be considered a constant. A constant may also be a number, positive (no sign), negative, and may contain decimal places. If no sign is present it treats the number as positive. If no number is provided after the negative sign (hyphen/dash) it will convert the value into T_NULL (NULL value due to - hyphen being represented as the NULL character representation). Constants may be escaped with the \ (back slash) character.
T_CONSTANT may be placed by them selves, after a comparator or as an argument to a function.
###Examples
| PQL | SQL | Comments |
|---|---|---|
"hi" |
'hi' |
|
'hi' |
'hi' |
|
"'" |
'\'' |
|
'"' |
'"' |
|
1 |
1 |
|
-1.5 |
-1.5 |
|
0.5 |
0.5 |
|
mul(id, -5) |
id * -5 |
|
mul(id, -5) > 5 |
id * 5 > 5 |