Predicates

Wed, 03/04/2009 - 20:02 |  hdanzl

Specify a condition that evaluates to a boolean value.


Syntax

<predicate> ::=
<search condition> ::= <boolean value expression>


Usage

Predicates are boolean value expressions, and can be used in SQL everywhere a boolean value is permitted.


Search conditions

The main function of the predicates is to specify a search condition that is used in data statements to join tables and filter out unwanted rows from a set, and elsewhere in SQL a conditional computation is specified. The search condition can be a single predicate or multiple predicates combined with the AND and OR boolean operators.


Conformance

SQL:2003 standard

NexusDB extensions

-

-

-

-

-

-

-

-

-

-

-

-

Core SQL

Feature F561 "Full value expressions"

Feature F281 "LIKE enhancements"

Feature F481 "Expanded NULL predicate"

Feature T501 "Enhanced EXISTS predicate"

Feature F291 "UNIQUE predicate"

Feature F741 "Referential MATCH types"

EQUIVALENT predicate

ODD predicate

INSERTING predicate

UPDATING predicate

DELETING predicate
‹ System FunctionsupComparison Predicate ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference

Powered by Drupal and Drupal Theme created with Artisteer.