Alternatives

Many examples in GoToAssist documentation include capitalized reserved words such as SELECT and FROM, on multiple lines to make it easier to discuss the parts of a query. But this is not required.

PQL is not case-sensitive. And PQL supports queries using equivalent structures. You can write queries on a single line or multiple lines, using upper or lower-case letters, including nesting. The following two structures are equivalent:

                              SELECT bar, baz                  
 FROM /network/device
 WHERE a = b 

 select/network/device[a = b](bar, baz)
   

You can rearrange PQL tree expressions as follows:

SELECT *                          
 FROM /network/device              
 WHERE a = 'b'

SELECT * 
 FROM /network/device[a = 'b'] 
              

The following structures are not quite equivalent but produce similar results:

SELECT *
 FROM /network/device                      
 WHERE a[name = 'eth0'] = 'b'

SELECT * 
 FROM /network/device/a[name = 'eth0'] = 'b'

Related topics

• Return to statements
• SELECT
• INSERT
• MERGE
• UPDATE
• DELETE
• Alternative structures
• More about PQL

| Views: 1324 | Last Updated: Thu, May 09 2013 2:28 PM

Is this article helpful?