Relational and Logical Operators: Difference between revisions

Latest revision as of 07:16, 6 January 2012

Relational and Logical Operators

Relational refers to the relationships that values can have with one another, and logical refers to the ways in which true and false values can be connected together. Since the relational operators produce true or false results, they are often used in combination with the logical operators.

The relational operators are as follows:

Operator	Meaning
==	equa to
!=	Not equal to
>	Greater than
<	Less than
>=	Greater than or equal to
<=	Less than or equal to

Those relational operators cannot be applied to all data types and in some cases, two values of different types cannot be compared to each other.

	array	bool	number	question	range	string	datetime
array					==, !=
bool		==, !=	==, !=			==, !=
number		==, !=	==, !=, >, <, <=, >=		==, !=
question
range	==,!=		==, !=
string		==, !=	==, !=			==, !=
datetime							==, !=, >, <, <=, >=

The logical operators are shown next:

Operator	Meaning
&&	Logical and
\|\|	Logical or
!	Logical negation

The outcome of the relational and logical operators is a value of type bool.

@@ Line 57: / Line 57: @@
 Those relational operators cannot be applied to all data types and in some cases, two values of different types cannot be compared to each other.
-<tbody><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">array</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">bool</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">number</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">question</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">range</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">string</strong></p></td><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">datetime</strong></p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">array</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">bool</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">number</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=, &gt;, &lt;, &lt;=, &gt;=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">question</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">range</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">string</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td></tr><tr align="left" valign="top"><td style="border:1px solid #010101;" bgcolor="#C0C0C0" width="149"><p class="bodytext"><strong class="specialbold">datetime</strong></p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">&nbsp;</p></td><td style="border:1px solid #010101;" width="149"><p class="bodytext">==, !=, &gt;, &lt;, &lt;=, &gt;=</p></td></tr>
+{| width="100%" border="1" cellpadding="1" cellspacing="1" align="left"
-</tbody><br>
+|-
+|
+| array
+| bool
+| number
+| question
+| range
+| string
+| datetime
+|-
+| array
+|
+|
+|
+|
+| ==,&nbsp;!=
+|
+|
+|-
+| bool
+|
+| ==,&nbsp;!=
+| ==,&nbsp;!=
+|
+|
+| ==,&nbsp;!=
+|
+|-
+| number
+|
+| ==,&nbsp;!=
+| ==,&nbsp;!=, &gt;, &lt;, &lt;=, &gt;=
+|
+| ==,&nbsp;!=
+|
+|
+|-
+| question
+|
+|
+|
+|
+|
+|
+|
+|-
+| range
+| ==,!=
+|
+| ==,&nbsp;!=
+|
+|
+|
+|
+|-
+| string
+|
+| ==,&nbsp;!=
+| ==,&nbsp;!=
+|
+|
+| ==,&nbsp;!=
+|
+|-
+| datetime
+|
+|
+|
+|
+|
+|
+| ==,&nbsp;!=, &gt;, &lt;, &lt;=, &gt;=
+|}
-<br>
+<br> <br>
 The logical operators are shown next:
@@ Line 88: / Line 160: @@
 |- valign="top" align="left"
 | width="594" style="border:1px solid #010101;" | &nbsp;!
-! Logical negation
+!
+Logical negation
 |}