-
Notifications
You must be signed in to change notification settings - Fork 0
Functions
Nathan Bruer edited this page Oct 10, 2015
·
1 revision
Functions are one of the powerful parts of PQL. Custom functions can be written and hooked into the PQL library to enable special SQL functionality to occur in function form. This is also the area that is used to execute real database SQL functions. You may embed functions inside each other (except group functions). Arguments are separated by a , (comma). Function names are not case sensitive. If a function is a group function it will auto add it to the HAVING section instead of the WHERE section.
#Examples
| PQL | SQL | Comments |
|---|---|---|
if(id>5, "ID is greater than 5", '< 5') |
IF(id > 5, 'ID is greater than 5', '< 5') |
|
COUNT(id) > 5 |
COUNT(id) > 5 |
|
| ` |