content_image/854102.jpg
## 12.4.2 Comparison Functions and Operators 

<img src='content_image/854102.jpg'>

Comparison operations result in a value of 1  ( TRUE ), 0  ( FALSE ), or NULL . These operations work for both numbers and strings. Strings are automatically converted to numbers and numbers to strings as necessary. 

The following relational comparison operators can be used to compare not only scalar operands, but row operands: 

= > < >= <= <> != 

The descriptions for those operators later in this section detail how they work with row operands. For additional examples of row comparisons in the context of row subqueries, see Section 13.2.11.5, “Row Subqueries” . 

Some of the functions in this section return values other than 1  ( TRUE ), 0  ( FALSE ), or NULL . LEAST()  and GREATEST()  are examples of such functions; Section 12.3, “Type Conversion in Expression Evaluation” , 

