Constants

Constants

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
if(like(name, "foo"), -, 1)	IF(name LIKE 'foo%', NULL, '1')