Contents Menu Expand Light mode Dark mode Auto light/dark, in light mode Auto light/dark, in dark mode Skip to content
FoundationDB Record Layer documentation
FoundationDB Record Layer documentation
  • Overview and Examples
  • Getting Started Guide
  • Building
  • Schema Evolution and Meta-data Maintenance
  • Extending the Record Layer
  • Versioning Guide
  • Coding Best Practices
  • Release Notes
  • Frequently Asked Questions
  • SQL Reference
    • SQL Data Types
    • SQL Commands
      • DQL
        • SELECT
        • WITH
        • WHERE
        • EXPLAIN
        • Operators
          • Logical Operators
            • EXISTS
          • Comparison Operators
          • IS Operator
      • DDL
        • CREATE
          • CREATE SCHEMA TEMPLATE
          • CREATE DATABASE
          • CREATE SCHEMA
          • CREATE TABLE
          • CREATE TYPE
            • CREATE TYPE AS STRUCT
            • CREATE TYPE AS ENUM
          • CREATE INDEX
        • DROP
          • DROP SCHEMA TEMPLATE
          • DROP DATABASE
          • DROP SCHEMA
      • DML
        • INSERT
        • UPDATE
        • DELETE
    • Functions
      • Aggregate Functions
        • BITMAP_CONSTRUCT_AGG
      • Scalar Functions
        • BITMAP_BIT_POSITION
        • BITMAP_BUCKET_NUMBER
        • BITMAP_BUCKET_OFFSET
    • Databases, Schemas, Schema Templates
    • Tables
    • Indexes
    • Direct Access API
    • Understanding How Bitmaps Identify Distinct Values
  • API
    • fdb-java-annotations
    • fdb-extensions
    • fdb-record-layer-core
    • fdb-record-layer-icu
    • fdb-record-layer-lucene
    • fdb-record-layer-spatial
    • fdb-relational-api
    • fdb-relational-core
    • fdb-relational-cli
    • fdb-relational-grpc
    • fdb-relational-jdbc
  • Contributing
  • Code of Conduct
  • License
Back to top
View this page

Logical OperatorsΒΆ

  • EXISTS
    • Syntax
    • Parameters
    • Returns
    • Examples
      • Existence of an element within an array

TODO: flesh out doc

Left Operand

Right Operand

OR

AND

XOR

TRUE

NULL

TRUE

NULL

NULL

FALSE

NULL

NULL

FALSE

NULL

NULL

TRUE

TRUE

NULL

NULL

NULL

FALSE

NULL

FALSE

NULL

NULL

NULL

NULL

NULL

NULL

Next
EXISTS
Previous
Operators
Copyright © 2025, Apple Inc.
Made with Furo